AdvancedFilter seems to work well when number of rows to be copied is
less than 1000, but when more than 1000 rows are to be copied all of
the rows in the database are copied. Is there a way to get more than
1000 rows at at time?

My application takes rows from one workbook to another after the user
has manually filtered the database. The column headers order may be
different in the source workbook than the destination workbook. I use
a unique key in the criteria range.

The only way I can think of doing this is to do multiple AdvancedFilter
copies and offset the CopyToRange (with headers) and then delete the
headers.

Any suggestions?

Thanks.