I need to write a desktop application that takes two excel files as input and compares both files are returns the difference.
The first file is the original stock file, that includes item code, barcode, quantity and expiry and the second file is the stocktake file received from the stocktake machine that includes barcode, quantity and expiry. The application needs to look at the new file and finds rows with same barcode and same expiry and merge it and add the quantities. For example, if there exist two rows with barcode 1234 and expiry 01/2018 with first having a quantity of 1 and the second as 2, it needs to merge into a single line with barcode 1234, expiry 01/2018 and quantity 3.
The application needs to return the following:
Quantity differences based on barcode+expiry
Items in original file that didn't exist in the new file
Items in the new file that dont exist in the first file
Items in the old file with no barcodes
I've done the project and have a sample version available but can't see how to attach it to this bid so I've put in up on one of my web sites for you to download if you care to
[login to view URL]
Comparing 2 Excel Files will be Slow
The Best Idea is to Submit data from file1 into a table1 in an Access database
and file2 into table2
and then you can get all Queries you want veryyyyy faaaaast
and i can do it for you