1 Attachment(s)
Compare Two Sheets and Extract Differences
I already have a macro that will compare two worksheets and highlight differences. Now, I need a report that would be in a separate worksheet called “Report”.
- Wherever there is anything highlighted in the row, I want that whole row copied and pasted into “Report” sheet. “Status” column should be marked as “Change”.
- If there are any new rows in “New” sheet they should be copied and pasted in “Report” sheet. “Status” column should be marked as “Add”.
- In the case that there are some missing rows in “New” sheet, but they existed in the “Old”, I want those rows copied and pasted from “Old” into “Report”. “Status” column should be marked as “Missing”.
Please see attached sample file. Let me know if you need more information. I appreciate help on this.