ExcelBanter - Copy to in Adv filter deletes data in lower rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copy to in Adv filter deletes data in lower rows (https://www.excelbanter.com/excel-discussion-misc-queries/91195-copy-adv-filter-deletes-data-lower-rows.html)

Hari

Copy to in Adv filter deletes data in lower rows

Hi,

Not an issue, but I noticed this today only.

If I apply advanced filter and copy the output to a new range lets say
A1:D1, then previous data in A1:D65536 gets deleted/cleared. This
happend even if thenew filter occupies just lets say 3 rows.

Regards,
HP
India

All times are GMT +1. The time now is 04:44 AM.