| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to panes by changing value in a cell - is it possible?
If D1 contains sheet name Panel8, or Panel9
=indirect(D1 & "!A1) "Dallas" wrote: I think I need to explain more/better: lts say I am in the overview sheet, and I have the following formula, which links to A1 in Panel8: =Panel8!A1 What I want is a cell in the overview sheet, where I can type, Panel8, or Panel9, or Panel10, etc, and when I do the formula above changes accordingly to =Panel8!A1, =Panel9!A1, =Panel10!A1 etc. The point is, in other words, to change the linking dynamically. I hope this makes things clearer. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Changing Values Between Worksheets | Excel Discussion (Misc queries) | |||
| linking an icon to a changing adjacent hyperlink | Excel Discussion (Misc queries) | |||
| Linking to Workbooks with Constantly Changing Names | Excel Discussion (Misc queries) | |||
| More Dividers for Excel Viewing Panes / multiple panes per axis. | Excel Discussion (Misc queries) | |||
| Linking changing data | Excel Discussion (Misc queries) | |||
Threaded Mode
