Hi,

I want to copy rows from 1 worksheet to another but only if they value in
column A= 'Yes'
So for example In worksheet1 I have 10 rows. 6 of those have 'Yes' in column
A and 4 have 'No' in column A.
In worksheet2 I would like to see only those 6 rows from worksheet1 which
had 'Yes' in column A.

I would like to do this using worksheet functions if possible, not macros.
also filtering is not good enough, I want to actually eliminate all those
rows that are 'No'

thanks for any help
Cheers