I am very new to Excel-VBA. The requirement is simple but I dont know any complex formulae or VBA,
Two columns (E and F), from two worksheets, need to be taken as a single composite column and compared with each other (the composite key is always unique).
This is the first sheet with the old data:
This is the second sheet with the new data:
For each matching combination of (Col E concat Col F) in both sheets, the difference (if any) of the amounts in column "I" needs to be calculated and this should be displayed in sheet 3 as below with the yellow highlights:
Two columns (E and F), from two worksheets, need to be taken as a single composite column and compared with each other (the composite key is always unique).
This is the first sheet with the old data:

This is the second sheet with the new data:

For each matching combination of (Col E concat Col F) in both sheets, the difference (if any) of the amounts in column "I" needs to be calculated and this should be displayed in sheet 3 as below with the yellow highlights:
