-
Using embedded spreadsheets
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules