Linking worksheets in the same workbook by names not cells

  • Thread starter Thread starter rohobby
  • Start date Start date
R

rohobby

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.
 
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.
 
Back
Top