Hi

Is it possible to create a macro to do this?

I have a table with the left hand column containing sequential numbers
say 1 to 100 (i.e. 100 rows).  The next column has a name associated
with that number.  There is a later section in the document associated
with each of those names and in that section there is a table
containing the same name (or shortened version of it) and the
associated number.

At some stage, the numbers in the main table may change  e.g. if a
line is added or deleted at row 50 then the numbers following go up or
down by one   - the number in each of the individual sections also
then has to go up or down by one so that it is the same as the number
associated with the name back in the main table.  Updating the numbers
in the main table is fairly easy (I think), but having updated them
(e.g. by copying from somewhere) I need to run a macro on each row of
the table to update the "remote" numbers.

I can create a bookmark back in the main table to link to the number
in the later part of the document but to get to the destination of the
bookmark you have to do CTRL Click in the main table  - which doesn't
work during macro recording.

I would prefer not to use "linked text" and paste special because the
link seems to get lost fairly easily e.g. if you overwrite it with a
new number, say by regenerating the entire column of numbers by
copying in from Excel.

Thanks for any suggestions.

Graeme