I couldnt decide which was better among the two
There are probably more methods to get the same results:

- a databasequery
- putting the data into an array, filter that in memory and writing the results to separate worksheets

If you post a sample file we all can do some testing and compare the results.