Combine Workbook with invoice?

[Falcon]

I have created a workbook which has all of my inventory in it. In eac
row I have a cell in which I enter how many of that item I want. A
the end of the row it gives me the total price. The last sheet of th
workbook gives me the total of all the items picked.
Now what I want to be able to do is, when ever I enter how many of a
item I want, it would automaticly add it to an invoice. I have bee
trying to figure out how to link the invoice and workbook together bu
have had no success. If any one has any idea how to do this, I woul
realy appreciate the help.

Thanks, To

 

[Frank Kabel]

Hi
see your reply in Excel.worksheet.functions