I have attached a spread sheet which demonstrates what I need to do which is:
Sheet 1 and Sheet 2 start out with the exact same details.
Sheet2 is updated with ‘New, amended or deleted’ details ad this is highlighted by the user in column ‘N’
I need my macro to:
1] review sheet 2 against sheet 1 and where any new items are on Sheet 2 put those lines onto a new tab called ‘New’ [assume this tab did not exist only sheets 1 and 2]
2] copy any items from Sheet 2 that have been amended onto a new tab called Amend_Delete
Appreciate any assistance with this