Advanced Filter Macro

A

Alex.W

Spreadsheet "Register" has columns A to Q of data. I want to move all data in
rows where there is an entry in the corresponding cell in column "P".

I want to move the data to Spreadsheet "Closed". Both spreadsheets are set
up identically for columns and headings.

Rather than paste over existing data in "Closed", I want it to be pasted
from the next vacant row down.
 
D

Dave Peterson

Why not record a macro when you use Data|Filter|Autofilter.

You can filter to show the nonblanks, then copy the visible rows (avoiding the
header) and past under the last used row.
 
Top