Extract information from data

Originally Posted by mtwa1990

is there no other way?

There are a million ways to do anything pretty much in Excel

What is the reason you don't want to do what I had suggested? It is a simplified answer and gives the user a lot of flexibility when using tables (with filtering and sorting). I'm not saying what I had suggested is correct because it may not be based on how you are using the spreadsheet, so I'm just trying to get more information so you can get a better answer.

And yes, you can create a macro that will take the records you want and copy them over to the other sheet, and that might be the way to go, but again, you need to balance complexity and simple with usefulness.