Adv. Filter - Want to copy to inactive sheet

M

Maki

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?
 
Top