Linking worksheets in the same workbook by names not cells
 

I have a workbook with 4 worksheets that contain resident information by
address, by lot numbers etc. Cell numbers are not the same on each worksheet.
Can these worksheets be linked so that a change on one be updated on all 4?
Excel 2003.

Linking worksheets in the same workbook by names not cells
 

It's difficult to say without knowing more about how things are laid out on
the 4 sheets and how the sheets are used. If one sheet acts as the master
sheet, the others could be updated via VLOOKUP() formulas alone. If you
don't use one as a master sheet, then things could really get complex and
possibly require VBA code to keep synchronized.

"rohobby" wrote:

I have a workbook with 4 worksheets that contain resident information by
address, by lot numbers etc. Cell numbers are not the same on each worksheet.
Can these worksheets be linked so that a change on one be updated on all 4?
Excel 2003.