Need to move data that matches criteria in cell and move to new worksheet

Hi, panagle,

I would like to move data, the entire line, from a sheet named "Days Open" that contains the words "On Hold" in column G, and move it to a spreadsheet named "On Hold".

Starting a macro that loops through all cells on that sheet or better uses the Autofilter to narrow down the number of line, copy all visible cells under the header and insert them after the last filled line in the destination sheet, delete the lines in the original Sheet, disable the Autofilter? Or start the process as an event (by entering the value into any cell on Column G or using Data/Validation, on activating the sheet)?

Right click on the Sheet Tab for sheet "Days Open", insert the code, any change to column G with on hold will cut and amend the row to "On Hold":

Please Login or Register  to view this content.

Please make sure that there will always be data in Column A as this is checked for the last entry, otherwise alter to suit.


Ciao,
Holger