Linking worksheets in the same workbook by names not cells

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.
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked cells between worksheets and sorting 2
Linking blank cells 1
Linking Formulae Across a Workbook 2
Linking multiple ranges and worksheets to MS Word 1
Sorting in multiple worksheets 1
Paste Values in linked Cells Only 4
linking cells between worksheets 1
Linking multiple worksheets in one workbook 2

Top