Advance Filtering

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

In advance filtering you can copy to another location with
that worksheet. But can you copy to another worksheet
where the list of data is not located?
 
Yes, you have to start from that other sheet, assume you want to filter
Sheet1!A1:C100,
start by selecting for instance A1 in Sheet2, do data>filter>advanced
filter, now in the list range box
either select Sheet1!A1:C100 or type in Sheet1!$A$1:$C$100, get the criteria
range unless you are using
unique records only, select copy to another location and click in that box,
then click Sheet2!A1, click OK

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
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

need help on either doing a loop and counting specific values orusing subtotal function 2
"save as" 0
Calculations in filtered columns 4
how do i extract records 4
What are the steps to fix damaged MDF files in SQL Server? 0
Advanced Filter, Copy to another location 6
Advanced Filtering 3
Data changes in advanced filter 2

Back
Top