| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking of worksheets in a workbook | Excel Discussion (Misc queries) | |||
| Linking to worksheets from another workbook | Excel Discussion (Misc queries) | |||
| Help creating workbook with worksheets "linking" cells | Excel Worksheet Functions | |||
| linking several worksheets to one workbook | Excel Discussion (Misc queries) | |||
| Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
