Copy Row based on cell entry

[Sharp]

Hi,

is there a way that you can do the following??

If any of the following terms LOST,FOUND,HELP are in column 'E', then copy the entire row which has this term in it from the tab called 'MASTER' to the tab called 'LOST'??

[mudraker]

Try this macro

It assumes the 2 sheets and the macro are in the same workbook

It uses column A to identfy last used row on each sheet
If macro is run more than once it appends each matching item to the next vacant row

It copies values ony - No formating

Please Login or Register  to view this content.

[ravishankar]

Hi
try the following codes

Please Login or Register  to view this content.

Ravi