I made a price list form as a PDF that users can fill in and save. However, it does not calculate. (SaleFormFinal.pdf)
So, I made an invoice form in Excel (PassoverFormCalculate.xlsx), now I want to connect it so that users can put numbers next to the items they want on the price list, and it will create a line on the invoice form with SKU#, product description, price, quantity and total for that line. For now the invoice form has drop-down lists, which is fine for more tech-savvy users, yet the price list has 665 items (it's for a wine store), so people really want to look at the whole list. The original list is in Excel, then copied into Word to layout into columns, then made into a pdf. I tried embedding the Excel invoice form into the Word file, yet that didn't work (Passover2013-saleform-test.docx).
The eventual goal is to have a PDF form with the existing price list, that will create a summary invoice form, and put this on our website (which currently has the non-calculating pdf form).

Any suggestions or advice are greatly appreciated!

To see what I'm talking about, here are the relevant files:
SaleFormFinal.pdf
Passover2013-saleform-test.docx
PassoverFormCalculate.xlsx