Copy cells to new worksheet but only IF
 

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

Copy cells to new worksheet but only IF
 

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.

--
Regards,
Tom Ogilvy

"nejl" wrote in message
...
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