Copying filtered data using advance filter to another sheet

  • Thread starter Thread starter bandula
  • Start date Start date
B

bandula

Hi All

Can anybody tell me how to copy filtered data usiing
advance filter to another worksheet (not the one
containing list)

Thanks Bandula
 
Hi,

you could start from the other sheet and then
copy the list when you filter or you could select the
filtered list. Press F5, click Special and select visible
cells, copy and paste..

Regards,

Peo Sjoblom
 
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

Adv. Filter - Want to copy to inactive sheet 7
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
VBA: How can I use a string variable as autofilter criteria? 4
unique records by advanced filter 10
Adv. Filter - Want to copy to inactive sheet 1
filtering results to another sheet 2
Advanced filter to another sheet 1
Filtering with SUMIFS 1

Back
Top