Hello, This is what I have.. I have 3 tabs "sales order", "price", "inventory"

The sales order tab has vlookup formulas so when I enter a part number it pulls description and price from the price tab, then I enter a "QUANITY" and it gives me a total cost. It also has a macro that allows me to print the sales order. (the sales order is one page when printed)

The price tab is a rather large list of part numbers and prices. (the price sheet is 50 pages)

The Inventory tab has vlookup formulas so when I enter a part number it pulls description from the price tab and i enter a "QUANITY" to say how many of that Item I need for my truck. This also has a macro to print the inventory request form. (this is one page when printed)

This is what I would like to do...
Copy the "price" tab and create another tab "Truck inventory" the truck inventory would have the part number and description and 3 columes "qty recieved" "qty charged" "qty on-hand". I would like to have the "qty recieved" pull the qty from the "inventory" tab and the "qty charged" pull the qty from the "sales order" then subtract the two to get "qty on-hand"

I think I might be able to figure out the subtraction part.