Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to panes by changing value in a cell - is it possible?
Hi,
Let's say I have 10 panels, which I have called 1, 2, 3, ... 10. The structure of the content in the 10 panels is identical, but the data is not. Let's say that I have created and panel that I call 'overview'. In this 'overview' panel, I have a cell, where I can type the name of a panel (say the number 8). When I change this value, the formulas in the 'overview' panel change in the sense that they now link to the panel I have typed (say 8). Is this possible, and if so, how? |
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) |