I need vba code that will search each row in column C on Admin(Sheet1) to see if it meets a certain criteria (the criteria -- column N must have a date in it in order for the row to be selected. If the criteria is met then copy that row and paste onto Archive(Sheet2) in the next blank available row. Then the data that was just copied and pasted to Archive(Sheet2) needs to be deleted from Admin(Sheet1). There will be multiple rows that will be copied and pasted at any one time. I greatly appreciate any help. I have been trying to figure this out for weeks now and I no proficient enough in vba to figure it out.
Thanks in advance!