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)
 
Back
Top