Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking cells in two separate sheets
Tom,
try: =INDIRECT("main!"&CELL("address")) keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Tom Atkisson" wrote: I have two sheets in a workbook. I have a Main and a Workspace sheet. I want to link cell from Workspace to certain cells in Main so that the information is the same on both sheets if Main is updated with new info. I have tried the formula =Main!B3 (also tried =Main!$B$3) in the appropriate cell in Workspace (B3). The problem with this is that when Main has insertion or deletion of a line the formula changes to point to the cell that had the value that it was initially pointing to. What I would like is for B3 in Workspace to always point to B3 in Main even if lines are deleted or inserted. Any help would be appriciated. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking cells on between multiple sheets | Excel Discussion (Misc queries) | |||
Linking Cells from different sheets | Excel Discussion (Misc queries) | |||
Linking cells between sheets | Excel Worksheet Functions | |||
Linking cells between sheets | Excel Worksheet Functions | |||
Linking cells between sheets | Excel Worksheet Functions |