First of all ive posted here but had no response https://www.excelforum.com/exc…n-7-days.html#post5663938
What it is I have 2 workbooks that has data and the layout of it is the same in both books.
Workbook 1 has data that has had some used and deleted from sheet. Workbook 2 has new data and the old data ive used redownloaded. This is where I need to compare the 2 sheets and delete the used data from the new download.