Compare list on sheet 1 to list on sheet 2 to find variance

[bellicusa]

I attached an example of the lists I get.

I would like to be able to total all similar items on sheet 1 (based on item code) and compare to the list on sheet 2 (will never have duplicates) so I can find the difference between the two totals.

Thanks,
Anthony

[FDibbins]

sheet 2 (will never have duplicates)

Not so

This is from sheet2...
A9&A10 are the same
as are B8 and B10
However, this will sum the contents oif sheet1 based on sheet 2...
=SUMIF(Sheet1!$B$2:$B$15,Sheet2!B2,Sheet1!$D$2:$D$15)
If you want to show where there is a difference...
=IF(SUMIF(Sheet1!$B$2:$B$15,Sheet2!B2,Sheet1!$D$2:$D$15)<>D2,"Variance","")

[bellicusa]

Not so

This is from sheet2...
A9&A10 are the same
as are B8 and B10

Sorry for the confusion. I tried to put together something real simple to show what I was looking for and missed the mark on that.

I have a new file attached now that is an accurate representation of what I am trying to find.

What I am trying to accomplish is:
1. Look at the first item on sheet2 (AB5454-F03 lot 140055)
2. I would like to add all remaining quantity (column c) of that exact combination from sheet2.
3. Compare that sum to the sum of all exact material (Item No. and Lot No.) from Sheet1.
4. If there is a difference, put that in column D on sheet2.
5. Repeat process for every unique Item and Lot combination on Sheet2.

Im hoping that makes at least a little sense.

Thanks,
Anthony

[bellicusa]

Any other information that I could add that might help?

Thanks,
Anthony

[bellicusa]

Hoping a few others might see this.
Not sure how to progress...just hate to have to do this manually every few days.

Thanks,
Anthony