Copy New Inventory Items To Sales Sheet

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.

You get better help if you post an Excel-example of your workbook, without confidential information.
Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.
Use BEFORE/AFTER sheets if that helps make it clearer.

Hello tido208 ,

Welcome to the Forum!

The quickest way to develop a solution for you would be to have a copy of the workbook. If it contains any sensitive information, please redact it before you post.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.