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.