Hello Excellers,
I've been looking/adapting code for quite a while for my problem and I can't quite find a code that will help me so I hope you guys and gals can.
I am looking to move entire rows of data based on criteria in column K (either 'Closed' OR 'Cancelled') from one sheet (ChangeRegister) to another sheet (Archive), then to delete the empty rows on the source spreadsheet. This is for use by other people including me so I don't want to put the code straight in the VBA editor, rather I will attached it a button to be pressed once a week.
Spreadsheet attached.
Any help would be really fantastic.
K
Bookmarks