Help!!! Am at a loss ![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
How do i write a macro that would look for a string (Numeric e.g. "999") in colum's 'O' - 'T'? (Columns 15 - 20)
If the string is found, i want it (the macro) too copy that entire row to a 'new' sheet (Sheet2) in the same workbook and delete the row from Sheet1?
To explain - On searching column 'O' and if string found; copy row to Sheet2: delete row from Sheet1; and then search column 'P' and so on until data sucessfully copied/deleted??
Difficulty, I have is that the same string can be repeated in different columns and unless the row once copied to 'new' sheet is deleted I would have the same 'row' copied over to Sheet2 from a different column - skewing the resulting data.
Hope this makes sense!![Laugh :LOL: :LOL:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Laugh :LOL: :LOL:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Many Thanks
MVX
How do i write a macro that would look for a string (Numeric e.g. "999") in colum's 'O' - 'T'? (Columns 15 - 20)
If the string is found, i want it (the macro) too copy that entire row to a 'new' sheet (Sheet2) in the same workbook and delete the row from Sheet1?
To explain - On searching column 'O' and if string found; copy row to Sheet2: delete row from Sheet1; and then search column 'P' and so on until data sucessfully copied/deleted??
Difficulty, I have is that the same string can be repeated in different columns and unless the row once copied to 'new' sheet is deleted I would have the same 'row' copied over to Sheet2 from a different column - skewing the resulting data.
Hope this makes sense!
Many Thanks
MVX