If change in one column using specific word, then copy row to another tab, repeat.

I have a worksheet that is now being used for department quality control. There is a comments column ("F") that if a specific word shows up "fail" (xlPart since there may be more comments), I need that row which contains that word (source) to be moved to another spreadsheet (destination). This is a dynamic document, so once that is moved over that row might be deleted from the source tab and a new row added not containing that word. Yet the next row added to the source might have that specific word show in column F and I need that row moved over and placed after the first instance and so on and so forth until the document is complete (a single word signifier which I trap and lock the document).

This might be simple and I'm over thinking it, but I typically don't use Worksheet_Change or Worksheet_SelectionChange and it's causing me some headaches. Any help would be greatly appreciated. Thank you.

Originally Posted by mastro78

I have a worksheet that is now being used for department quality control. There is a comments column ("F") that if a specific word shows up "fail" (xlPart since there may be more comments), I need that row which contains that word (source) to be moved to another spreadsheet (destination). This is a dynamic document, so once that is moved over that row might be deleted from the source tab and a new row added not containing that word. Yet the next row added to the source might have that specific word show in column F and I need that row moved over and placed after the first instance and so on and so forth until the document is complete (a single word signifier which I trap and lock the document).

This might be simple and I'm over thinking it, but I typically don't use Worksheet_Change or Worksheet_SelectionChange and it's causing me some headaches. Any help would be greatly appreciated. Thank you.

Any thoughts on this? I'd appreciate anything since I've tried quite a few different things with no luck. Please and thank you!

The idea is that the Source tab is dynamic so what is in row 4 now might not be what is in row 4 hour to hour throughout the day. I just need a way to capture each row where column "F" contains the word(part of word) "Fail" and place it in the Destination tab. Never overwritting, but appending everytime. Thanks for any help.

Perfect, I can tweak it from there but fantastic. Thank you!