I am trying to compare two inventory sheets. For instance I have the last months inventory sheet (inventory test) and I want to compare it to the inventory sheet (the exact same sheet just with an updated inventory; Inventory test 2) that is turned in for this month. I would like for the differences to be added to another workbook (sales test). When the item is carried over, I would like for it to carry over the part number (Colum A on Inventory test), Part name (Colum B on Inventory Test) and the difference of the on hand quantity onto the "Sales Test" workbook in the corresponding cells.
If the above is to difficult or cannot be done. Can I get excel to at least compare the numbers in Colum E on "Inventory Test" to the numbers in colum E on "Inventory test 2" and and show the discrepancies with at least the number difference and part name in another worksheet?
Any help would be GREATLY appreciated.
I have also attached the above mentioned workbooks
Bookmarks