Please can you help with the attached?
Basically the command button "Archive" moves the values occupied in column B:S onto the next worksheet "Archive"
The problem I have is that I don't want to delete the rows transferred, I would just like to clear the values in column B:N & R
The reason is that the formulas need to stay in situ and will reset once the values have been cleared.
If possible I would like to cap the limit on the "Archive" from line 9 to line 60
One other thing is that unless a date has been added in column N, the line will stay upon the current worksheet.
If you press the command button it should demostrate
Many thanks for your help!