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,
Macro to copy a sheet to a new sheet after a filter and sort