Thread: Copy to in Adv filter deletes data in lower rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hari
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote