word insert data into excel

[elemental]

Hello,

I am using office 2010 Professional. Basically what I would like to do
is insert certain data from a word document into an excel cell.

For example if I type the word



Example1 into word (possibly in a table) then that is inserted into a specific cell in my spread sheet. (there is a specific need for this) unfortunately it is not as simple as just bypassing word and typing it straight into excel.

[macropod]

Hi elemental,

If you type something into your Word document, then copy it and choose 'paste link' in Excel, Word will create an OLE_LINK bookmark spanning that range, and the data between the document and workbook will be linked. If you edit the bookmarked range in Word (without deleting the bookmark), the Excel workbook's contents will update to reflect the change. The bookmarked range can include a table, in which case, the whole table will be linked and you can edit the individual cells.