Generating a file showing the difference

[djfscouse]

Hi,

I have an excel 2003 file that has column A showing its ID and B its quantity, then column C with its ID and D with their its quantity.

If there are more of the ID in column D than B then I want the output to be a file showing the difference.
It does not matter if column B has more than column D for the same SKU only if column D has less than column B for the same SKU.

Attached is an example of the ideal ExpectedResultFile.xls along with the Compare.xls file.

Below the starting information file

A B C D
SKU QTY Variant SKU Qty
901180103 19 901180103 6
901180107 0 901180107 1
901180113 7 901180113 8
WMEBLAC 28 WMIARM 13
WMEBRO 3 WMECHO 3
WMECHAR 27 WMECHAR 7
WMECHO 22 WMEBRO 26
WMIARM 70 WMEBLAC 55
WOCBLAC 2

Here are the ideal results in a excel.xls file after applying VBA

A B
Variant SKU Qty
901180107 1
901180113 1
WMEBRO 4
WOCBLAC 2

Thanks in advance for any help.

David

[Parth007]

Hi David.. Could you please confirm the input & output data you have attached in sheets.... i think there's a difference ...

Column D contains QTY & not ID.. i am puzzled

[djfscouse]

Sorry for the confusion, in the Compare.xls doc column A = column B quantity and column C = column D quantity. If the item in column C has a greater quantity than the item in column A then I need to display the difference in ExpectedResultFile.xls‎

Thanks for taking a look.