Auto Archive rows to separate sheet but retain data validation in original sheet

I am trying to automate an archive process for a spreadsheet I have which will need repeating on demand (presumably with a button).

I have attached a simplified version of the problem on an excel sheet. My real sheet has 800-900 rows and goes to column U, but the process will be the same.

I need to move old rows across, move the remaining rows to the top, but retain some data validation in certain columns. I am trying to determine if it is worth the amount of VB I will need to do this or whether it is simpler to do this manually.

Hopefully my sheet will explain it.

Hello chrisk67,

I have attached a simplified version of the problem on an excel sheet.

Ooops, there is none of same.

How to attach a Workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.