To extract the data to a different sheet, start the Advanced Filter from
the destination sheet, as described he

http://www.contextures.com/xladvfilter01.html#ExtractWs

teepee wrote:
"Roger Govier" wrote


With your data on Sheet1, in a range from say A1:F100, with A1:F1 holding
the headers, set up a table on Sheet2 with unique values from Sheet1


It says you can only copy filtered data onto the active sheet 8-(




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html