Hi
I need to automate the movement of rows in a spreadsheet from one sheet "Purchase Orders Raised" to another sheet "Archive"
This needs to be based on the date in column O "Confirmed Delivery" being in the past.
When the rows are cut from Purchase Orders Raised and pasted to Archive, they need to add to the next available row and not paste over existing data.
Any help would be appreciated!
Bookmarks