Macro to copy a sheet to a new sheet after a filter and sort

[Closed]
Report
Posts
3
Registration date
Tuesday November 22, 2016
Status
Member
Last seen
November 22, 2016
-
Hello,
I have a recorded macro that picks specific values in a list and sorts them to display only ones with those values.
What I would like to do is take those results and copy them to a new tab. I tried recording a macro that click in the top row and column, highlights all cells and then copies those results and pastes to a new tab.
It ends up copying only one value and not all the results.

Because this is used in multiple spreadsheets, I can't select a specific range to copy,