Copy/pasting info in tables

Hi Ana

If I'm understanding correctly, you would like to paste the result of the filters only?
Pasting as values only removes formatting and pastes the results of the formula.

What version of Excel are you using?
In 2016, you should be able to highlight the cells (NOT the rows or columns) and copy and paste.

If this isn't working, I'd recommend trying an advanced filter to copy the result of the filter of onto another set of blank cells.

To use an advanced filter, you will need a set of cells that you would type in to tell the filter what your criteria is.

If you go to Data > Advanced Filter, a box will open where you could filter in place or copy to another cell. Select the second option.
Your list area would be your database INCLUDING headings. This is important.
The criteria would be the set of cells that tell the filter what you're looking for. This has to include the headings from the database so that the filter knows what columns to look at.
Copy to will allow you to select a cell that you can copy the results of the filter to.

I have attached a workbook to show you how the criteria field would look like.

Hope that helps.

Kind regards
Wendy

Kind regards