Hi, We need a MS Word document reproduced into an Excel format; one that will auto calculate quantities, sub-totals, optional discounts, tax and grand totals (as shown on the Word Doc). The converted form needs to match the look of the existing Word Doc i.e., fonts, font sizes, background colors, general page layout. The form needs to be “lockable” so that users cannot undo formatted areas/items. And, we will need to be able to edit the form as needed i.e., expand number of items, add cost per unit, etc. Users should only be able to enter the quantities and indicate pertinent (and optional) discounts. The form would auto fill the rest of the info. Locked and unlocked versions of the Word Doc are attached.
