Invoice/Inventory merging ???

Hi all,

Quick question. I have an invoice template in excel. I want to create a drop down menu in the description column and have a list of all parts that I have so that I don't have to type each part out.

Now I would also like to have another spreadsheet for inventory and I would like to reference the inventory to the invoice.

Meaning If I have a sale, I'd like to go to the invoice and select the drop down parts list.....select part #1 and type in the quantity. Now if I sell 2 pieces of part#1, I would like to have the inventory automatically deducted as soon as I type in the sale in the invoice.

Any helpo you can provide is appreciated.

I am having the same problem. We are a tree farm and when we make an invoice we want to type in the Item# and then auto-fill the rest of the row with the tree's Common name & Cultivar (Both In Cell C14) and Price, then if we change the quantity, have it pull that from the inventory.

What type of formula would we use? VLOOKUP? Macro's? GETPIVOTDATA? Filter?


Much Thanks