Advanced Filter on next blank row

[Excelladder]

I have data in my spreadsheet in columns A thru P.

I use Advance Filter to move some of this data to another worksheet. If I want to run the Advanced Filter numerous times, how do I get it to place the filtered data on the next blank row instead of overwriting the previous filtered data?

Can a macro be written for this?

 

[frank_AL]

Yes this can be solved with a macro.

1. What is the name of your data sheet?
2. What is the name of the sheet where you want to copy the filtered data to?

In the simplest version, you would Filter the data manually and then execute the macro to copy that data to another worksheet. Would that be okay?

Let me know.