how do i copy rows to a new worksheet by a cell value

[Nibbs]

Hi,

I have a worksheet with many rows of values. Where a cell in a particular
column is "Yes" I wish to copy the values of that row to a different
worksheet.

Is this something suited to a macro?

Many thanks for any assistance.

Nibbs

 

[Don Guillett]

without a macro, use data>filter>autofilter>filter on yes>copy