You would have to use OLE or "embed" a spreadsheet into the Word document.
I am trying to design a simple form with a drop-down box containing "open" and "close." Based on the input in this drop-down, two other cells have to to reflect the chosen option, and the alternate one (i.e. if "open" is chosen, cell XX will read "OPEN" and cell YY will read "CLOSE," or vice-versa.
I can do this in Excel easily, but the formulas in Word just don't want to work. I have tried bookmarking the box, and can *copy* the bookmark value to a cell, but cannot use the bookmark in a formula.