Copy to in Adv filter deletes data in lower rows

H

Hari

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
 
Top