Hi, first time here. Not sure if this is a real VBA question or not.

I am setting up a questionnaire in a Word document. A number of the questions request input of data (rows and coulmns of data). I would like to use the data entered in one table (embedded spreadsheet) to populate certain cells of a subsequent embedded spreadsheet.

I thought I could use an embedded spreadsheet, copy the embedded object and use the different tabs (worksheets) of the spreadsheet to capture the data and have formulas between the worksheets to automatically populate the cells.

My problem is that I cannot find a way to link or reference one embedded spreadsheet to another.

Any suggestions would be greatly appreciated.