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