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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to panes by changing value in a cell - is it possible?
Use a formula like this in the 10 panels.
=Overview!A8 "Dallas" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking to panes by changing value in a cell - is it possible?
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. |
#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. |
Reply |
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) |