Advanced Filter

[Ray Bicker]

The excel Advanced Filter works fine for me with one exception. It populates the
Copy to range with the required data but also deletes everything in the rows
below that data. My List range is a table on another worksheet.

 

[Ray Bicker]

The excel Advanced Filter works fine for me with one exception. It populates the
Copy to range with the required data but also deletes everything in the rows
below that data. My List range is a table on another worksheet.

I have now learnt that this is to be expected when the 'Copy to another
location' is specified. Does anyone know why?. I am creating 7 reports using vba
to string together successive Advanced Filters. I have add to use a copy and
paste routine to reinstate the column headers as the reports move down the
worksheet which now works fine.