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

Embed the same Excel multiple times 0
Dealing with the error: unable to filter on excel hc home school 0
Code to format cells on several worksheets 2
Can the IF function be used with values from multiple worksheets? 4
Setting column width in a table with a macro is not working 0
Linked cells between worksheets and sorting 2
Import Multiple CSV Files from Same Folder into Open Workbook 5
Linking blank cells 1

Top