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?