Hello everyone,

I am new to VBA and I know this question has been asked multiple times. I have ready these responses, but I cannot seem to get any of them to work for me. I am trying to write a macro which will select any row in ws "Input-Project_Register" that has "Not Approved" selected in Column 'H' and cut and paste it into the first empty row in ws "Input-Archive" and select any row in ws "Input-Project_Register" that has "Completed" in Column 'BI' and cut and paste it into the first empty row in ws "Input-Complete". I want this macro to be assigned to an Active X control button.

Any help would be greatly appreciated. I am trying to get this figured out today so that it is complete by the start of work tomorrow.

Thank you in advance for any help!

Best Regards,

Nathan