Calculating differences between two sheets

[CanadianGSX]

Here's what I have:

3 worksheets - Sheet1 = Manual Inventory - Sheet2 = System Inventory - Sheet3 - Should display the difference of quantity between both.

The columns I have are: ISBN, Description and QTY

What I'm trying to accomplish: Match the ISBN from both Sheet1 and Sheet2, once matched, copy the ISBN, Description and the DIFFERENCE in QTY on Sheet2.

All the data starts in Cell A2.

I have a sub that works just fine as long as A2, A3, A4, etc... are the same on both sheets however, as soon as there is a discrepency, it stops.

Example:

Sheet1:

ISBN Desc QTY
111 AAA 2
222 BBB 3
333 CCC 2
444 DDD 1

Sheet2:

ISBN Desc QTY
111 AAA 2
222 BBB 2
444 DDD 2

Sheet3: (the resulting data)

ISBN Desc Difference
111 AAA 0
222 BBB 1

Stops here because the ISBN values are now different.

Any help on this would be appreciated....find below the sub I am currently using:

Thanks!

Lou

Please Login or Register  to view this content.

[stanleydgromjr]

CanadianGSX,

Welcome to the Excel Forum.

Detach/open workbook AdvancedFilter Unique ws1 ws2 to ws3 SUM IF - Calculating differences between two sheets - CanadianGSX - SDG13.xls, and run macro CalcDiff.

[CanadianGSX]

Solved with the following code:

Please Login or Register  to view this content.