Compare sheet and find difference

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

ID Department Amount
123 Finance 100
123 Education 200
123 Technology 30
123 HR 20.5
6165 Education 20.5
6165 Technology 45.6
6165 HR 30
6165 Hardware 120

Format (& data)of sheet 2 is
ID Department Amount
123 HR 10
123 Payroll 50
123 Technology 30
456 HR 20
456 Technology 30
6165 Education 20.5


I would like a result like this

ID Name Department Amount(Orig) Amount(New) Comment
123 John HR 20.5 10 Different
123 John Payroll Blank 50 Different
123 John Technology 30 30 Match
123 John Finance 100 Blank Different
123 John Education 200 Blank Different
6165 Harry Education 20.5 20.5 Match
6165 Harry Technology 45.6 Blank Different
6165 Harry HR 30 Blank Different
6165 Harry Hardware 120 Blank Different

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. I have also attached a sample file for your reference.

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

Originally Posted by vislavti

ID Department Amount
123 Finance 100
123 Education 200
123 Technology 30
123 HR 20.5
6165 Education 20.5
6165 Technology 45.6
6165 HR 30
6165 Hardware 120

Format (& data)of sheet 2 is

Originally Posted by vislavti

ID Department Amount
123 HR 10
123 Payroll 50
123 Technology 30
456 HR 20
456 Technology 30
6165 Education 20.5

I would like a result like this

Originally Posted by vislavti

ID Name Department Amount(Orig) Amount(New) Comment
123 John HR 20.5 10 Different
123 John Payroll Blank 50 Different
123 John Technology 30 30 Match
123 John Finance 100 Blank Different
123 John Education 200 Blank Different
6165 Harry Education 20.5 20.5 Match
6165 Harry Technology 45.6 Blank Different
6165 Harry HR 30 Blank Different
6165 Harry Hardware 120 Blank Different

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.

Please post a sample workbook indicating what your raw data looks like, what you expect/hope to see and why.

Regards

See attached: