Hey all! I have two sheets. The main sheet is my Master sheet that I work with daily, and the second sheet is a newly exported data which contains new lines and some removed lines.
I have Sheets:
Current
New
Current is the working sheet. I need to compare Column A in "Current" sheet and "New" sheet.
Firstly, any data existing in "Current" Column A but NOT existing in "New" Column A - the whole row should be deleted from "Current"
Second, any data existing in "New" Column A but NOT existing in "Current Column A - that whole row should be appended at the end of "Current"
I found some code online but it threw errors or crashed my Excel. I have attached spreadsheet for reference. My actual file has 3k + lines..I removed all but 10 lines for the test file. Thanks in advance!
Bookmarks