moving to another sheet depending on word

[[email protected]]

OK, this is my first time to use a forum for a number of years so here goes.

A1 has a text string say T2009011306
B1 has a text string like "The client just needed to reboot"
c3 has strings such as "completed" or some other word like "on test"or "UAT"

What I want is if the row has the word "completed" I want it to move from sheet 1(where the row resides) to sheet2. I am using Excel 2007 but I am guessing the same answer would apply to 2003

Thanks guys

[stanleydgromjr]

[email protected],

Here you go.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Press and hold down the 'ALT' key, and press the 'F11' key.

On the 'Insert' menu, click 'Module'.

Copy the below code, and paste it into the Module (on the right pane).

Please Login or Register  to view this content.

Then run the "MoveCompleted" macro.


Have a great day,
Stan

[[email protected]]

Hey, thanks Stan, I will have to apply to my situation. this will work.