I'm using Excel 2003 and I would like to link the text in one worksheet to
another one so that when it's modified it is automatically updated, e.g.,
when I add Bob Jones to my main worksheet, Bob Jones automatically shows up
in the second sheet. Any thoughts? Thanks

if the names are going to be in the same area of both workbooke just use the
= function

in the 2nd workbook put = in the cell and point it to what you want it to read


"RPGJR" wrote:

I'm using Excel 2003 and I would like to link the text in one worksheet to
another one so that when it's modified it is automatically updated, e.g.,
when I add Bob Jones to my main worksheet, Bob Jones automatically shows up
in the second sheet. Any thoughts? Thanks