Truck test.xlsxSales Ticket Test.xlsxInventory Test.xlsxI am trying to get excel to compare an inventory sheet to my master inventory sheet and then carry items that have changed over to a sales order. I don't know if this can be done and I am new to running Macros and other advanced tools in excel.
When an inventory sheet is turned in, I would like to pull the master inventory and have it compare colum E on the inventory sheet to colum K on the master inventory sheet. Then I would like it to carry over the part number, item name, cost and quantity difference to a sales order on another worksheet.
I have attached the workbooks. What I am looking for is:
1. Colum E on inventory test(light blue) be subtracted from colum K on truck test (light bue).
2. Then the difference, part number, cost and item discription brought over to the Sales test spreadsheet in the correct order and cell. In essence for it to generate the sales order reflecting the used items.
Any help or ideas would be great.
Bookmarks