Advance Filtering

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

 

[Peo Sjoblom]

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)