"Debra Dalgleish" wrote

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

Thanks - I'm now told for the same reason I can't use pivot with the
software I'm employing, it won't recognise advanced filter either, so I
have to use arrays on their own 8-(

Back to the drawing board