Hello -
I would like to find a way/macro to find out difference between two sheets matching certain criteria.
For example:
Format of sheet 1 is
Format (& data)of sheet 2 is
I would like a result like this
I would like to generate above report for IDs found in sheet 1 only. If you look at above example, ID with value exist in sheet 2 but not in sheet 1. This should not be reported in the result.
I hope I have made requirements clear. Please feel free to ask me if you have any question.
Bookmarks