Hi Bird Fat,

Interested in a non-vba solution? Without relying on Word's fragile bookmarks? If so, read on.

1. open both the Word doc and the Excel wb.
2. name each of the cells containing the data to be exported to Word
3. copy one of the cells containing the data to be exported to Word
4. in Word, use Edit|Paste Special, check 'paste link' and choose an appropriate paste format.
5. in Word, select the pasted value and press Shift F9 to expose the field code. It should look something like
{ LINK Excel.Sheet.8 "C:\\Users\\System\\Documents\\Technical\\Data.XLS" "Sheet1!R1C1" \a \r }
6. Change 'Sheet1!R1C1' to your Excel name for this address, then press F9 to update the field.
7. copy & paste the modified field to each of the other locations where you want data from the Excel wb to appear.
8. repeat steps 6 & 7, updating the range name to match the relevant locations in the Word doc with the Excel data.

Having done the above, adding/deleting rows/columns other than the named ones will cause the Word document to point to the new addresses in Excel. Having the links update automatically in Word is as simple as checking the 'update automatic links at open' option under tools|Options|General in Word.

If, perchance, you have an issue in that the named cells are liable to be overwritten or deleted (ie they don't get relocated), you could use a secondary worksheet in the Excel wb to retrieve the data from the primary worksheet (eg via a formula that retrieves the data from the last row), and use the secondary worksheet as the data source for the Word document.