Advanced Filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible using Advanced Filtering, to have the output go to a different
Sheet,
instead of the current sheet(database Sheet).

Thanks in advance.

Tony
 
In 2003, it asks (data, filter, advance filter) if the data should be copied
to another location. Don't know about other versions.

Carole O
 
Yes you can, but you need to start the filter on the destination sheet and
browse back to the data range you want to filter,
Regards,
 
Thanks Alan,

It worked like you said and it is exactly what I needed.

Tony
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering Using Values In A Specific Cell 3
Data changes in advanced filter 2
A function for filtering between Dates 4
Macro to copy value in field and insert it into filter 2
Count Advanced Filtered Rows 3
What are the steps to fix damaged MDF files in SQL Server? 0
Report cell from Filtered lists with text 1
Advanced Filter return blank 0

Back
Top