extracting data

Giganews Newsgroups
Subject: extracting data
Posted by:  Lisa Childers
Date: Sun, 7 May 2006

I have found several postings similar to this but none that gave me my
answer. I have a worksheet containing several thousand rows. I want to copy
all those rows from worksheet 1 to worksheet 2 based on a yes/no criteria in
column 1. I have tried advanced filter but it appears that this must be used
within the same worksheet. (Not what I want) I also want that new worksheet
to update as the criteria changes from yes to no or vice versa and as new
rows are added to the first worksheet.

Any suggestions?

Replies