Setup Purchase order template to auto calculate fields

[Mike Shimizu]

Office XP

I believe it was office 97 that had a purchase order templat you could
download that had formulas to extend unit price and subtotal the exteded
prices for all line items and total at the bottom.

All the templates I have seen do not have this anymore, they appear to be
just empty table fields you type in. The specific template I downloaded was
PO w/ unit price.

How do I create the formulas to have my PO template, calcualate automatically?

I have tried on line one of the PO where you input qty , unit, description,
unit price. In the total field, I tried Table-Formula. Tried =product(A1,A4)
, tried =product(A1:A4), tried =(a1*a4) none of these worked.

Then I tried designating the qty field with a text form field and formatting
to numeric. Did this for all releveant fields with bookmark names a1, a2, a3
, a4. Then tried all the variants of the formula I mentioned above. Still
nothing works.

I recall there was a macro that was needed for this to work back in the
Office 97 days. Which of course I do not have this macro or any idea how to
make it. Is this why it's not working for me now?

I do not see where my e-mail goes in this form so here it is:
mike.shimizu(remove this)@ccgir.com

 

[Greg Maxey]

You should get a good start here and the linked articles by Dian Chapman:

http://word.mvps.org/faqs/customization/FillinTheBlanks.htm

The forms decribed in the article above are oddly called online forms.
Using on line forms, you don't need a macro. You can use Textfields to hold
your QTY, Unit Price, Decription, and a Calculation field for the total.