Link worksheets in Excel

R

RPGJR

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
 
M

ME @ Home

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
 
Top