Help please to move row to a second archive sheet when a Marlett tick is selected in cell

[Danz1985]

Hello all,

Been looking for a solution for a week now and I have no knowledge on VBA at all. Hoping I can have some help here please?

I have a worksheet that has been created to try and make a job paperless. It stores information in cells D7 along to Q7 (likely to be extended to R) and down to row 99.

I'm trying to move the row when a Marlett tick is selected in Column O to the archive sheet. So that when the job is ticked as done it will auto move it. Cutting and copying the contents of the cells only so we don't lose borders and colours etc.
When moving to the archive sheet it would be great if it would go down to the next available or blank row. Also the deleted row in the front sheet to then have all the data below moved up to keep the sheet tidy and organised.

I'll include a copy of the blank sheet with some random data entered to assist in any testing. Edit: I am having trouble uploading, although the file size is 39mb.
To note there are some current VBA codes in there to enable Marlett ticks on selection, also another so that columns L and M can not have a Marlett tick in both columns on a corresponding row. Data Validation Lists are also present columns G and H.


Thanks for your help, would be greatly appreciated.

Any further questions and i'll try to get back and answered as soon as.

Thanks,

Dan