Pulling qtys from different tabs

**jackdpricejr** · 02-29-2012, 10:18 AM

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.

**arlu1201** · 02-29-2012, 11:00 AM

Why dont you attach a sample file with some dummy data?

**jackdpricejr** · 02-29-2012, 12:26 PM

I hope this is what you mean. I have deleted most of the file but you can see what you need i think. The sales order has a macro "button" to print the sales order and that is what I want to use to "update" qtys in the "truck inventory" (the sales dummy does not have the "truck inventory" tab created yet. But the "truck inventory" tab will just be a copy of the Parts on the price list with three columes for the qtys that are recieved, charged and running total on truck.)

The inventory tab also has a "print" macro that I would use to update that qty also

If this helps --- i work in a shop, i have to get parts from the shop and put on my truck, then I charge for the parts that I use and I am wanting to have a running total of the parts on the truck.

the formulas did not copy over but they are

=IF($C$6="","",VLOOKUP($C$6,Price!$A:$E,2,FALSE)) -- in colume D

=IF($C$6="","",VLOOKUP($C$6,Price!$A:$E,5,FALSE)) -- in colume F

**jackdpricejr** · 02-29-2012, 04:11 PM

It would have to see the qty in the qty colume and add that number to the quanity on the correct part number
is this even possible?

**arlu1201** · 03-01-2012, 06:59 AM

Thanks for the file. However, it would be good if you had put in some data into it so we can understand what you have. Why dont you also include a sample output tab (your truck inventory tab) so we can understand the output you are looking for, too.