Macro to Compare and copy info based on a serial Number

[Bennyton]

Hi all

I have a little bit of trouble with a macro.

I have 3 worksheets.

1 is a list of products in "Stop Mode"
2 is a list of products that are in "Go mode"
3 is a list of serials and next to them are definitions saying STOP and GO...

so what I want to do, is run a macro that will check worksheet 3,

so that IF column b has a value of "STOP",

then it will get the the serial next to it in column A,

and search through worksheet 2,

when it finds its match, it will cut that row,

and paste it at the bottom of worksheet 1.

it will then loop again to do the next one.... so the next one in worksheet 3 with a STOP Value.


It's rattling my brain at the moment, thanks for your help.

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=575617

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).