A: You will want to write a macro in Word to accomplish this. If you use the macro often, you'll probably want to assign the macro to a button in Word. Just follow these steps: ...

Word macros are one-click wonders that let you program complex procedures to launch at your bidding. Here are a few examples to get you started.

Click the cell in the Excel spreadsheet where you want the command button control to appear. The Assign Macro window opens automatically.