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

sparky

Yes, it is possible and quite easily done.

See Debra Dalgeish's site for instructions with pictures.

http://www.contextures.on.ca/xladvfi...html#ExtractWs

Gord Dibben Excel MVP

On Tue, 13 Apr 2004 18:21:29 -0500, sparky3883
wrote:

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 data
from Sheet 1.

I was informed that if i used Data|Filter|Advance Filter, that i would
be able to copy selected information from one sheet on to another.
However, when i came to do this, a message kept on appearing saying
'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 something
similar.

Thanks


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