View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maki Maki is offline
external usenet poster
 
Posts: 30
Default Adv. Filter - Want to copy to inactive sheet

Hi

Whenever I do Advanced Filter Copy to another location, Excel wouldn't
allow me to specify the destination (i.e. Copy to:) on worksheet other than
the one I'm currently working on.

Isn't there a way around this?

--
Maki @ Canberra.AU