Hi All

I have recently created a file that contains 2 Sheets.

Sheet 1 holds all my data and Sheet 2 is to hold certain bits of dat
from Sheet 1.

I was informed that if i used Data|Filter|Advance Filter, that i woul
be able to copy selected information from one sheet on to another.
However, when i came to do this, a message kept on appearing sayin
'Can only filter data in active sheet' (or something very similar).

Is it possible to filter data from one sheet to another?
If not, can someone please advise me on how i can do somethin
similar.

Thank

--
Message posted from http://www.ExcelForum.com