Copy cells to new worksheet but only IF

[Guest]

Hi,

I have a worksheet with several columns, each row contains data on a single
management option, the last colum (L) is labelled either YES or NO depending
on whether the option has been agreed to be actioned or not.

I need a macro to check each row, and if the final column (L) is a YES then
to copy the info in the first say 4 cells in that row to a new sheet, so that
at the end I have a new sheet with a list of actions to be implemented.

I would really appreciate help on this one,

Thanks in Advance

Nejl

 

[Tom Ogilvy]

just click in you data and do Data=>Filter=>Autofilter. Then go to the
column with Yes, No and in the dropdown select Yes. Select the first 4
columns and do Edit=>Copy, go to the new sheet, select A1 and do
Edit=>Paste. Only the visible rows are copied. Go back to the original
and do Data=>filter=>Autofilter to remove the filter.

If you need a macro, turn on the macro recorder while you do it manually.