Please can someone help me with the following scenario. I want to look through column B in Sheet 1 and where the word "complete" is present in column B, I want to remove the entire row and paste it into sheet 2, starting at the first blank row. Any suggestions for the required code would be greatly appreciated.
Thanks
Matt
This message was edited by Matt on 2002-04-16 11:23
This message was edited by Matt on 2002-04-16 11:38
Thanks
Matt
This message was edited by Matt on 2002-04-16 11:23
This message was edited by Matt on 2002-04-16 11:38