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
Bookmarks