having a link within a link

D

darrelly

Hi all-

I'm new here and hope that someone will be able to help me with this.
I am having an excel link problem.

Here is the scenario in basic terms. I have one workbook, in the
workbook i have 4 tabs labeled MASTER, SCENARIO 1, SCENARIO 2 and
SCENARIO 3

Scenario's all have the same format but have many different numbers in
them. The Master sheet has cells linked to scenario 1. A simple link
on the Master sheet would show up as follows:

='scenario 1'!A1

which basically means that it is pulling from cell A1 on the scenario
tab. Is it possible to have the "1" in this formula linked to another
cell so that if i just typed in 1 in that cell it would pull from
scenario 1's spreadsheet but if type in 2 it will automatically pull
from scenario 2's spreadsheet? I can't figure out how to put a link
within a link or if it is even possible. I hope my question makes
sense. Thanks for the help!

Darrell
 
D

darrelly

thanks for the help

I tried everything you said but i get #Ref! in the b2 cell where i
have this forumla

=INDIRECT("'"& $A$1 &" "& A2 & "'!"& B$1)

i cut and pasted your formula so i think i got it right
 
D

darrelly

I'll try that thanks. If I don't want the forumla to link to the b
cell but instead would like to put the actual cell i want linked ther
on each tab how do i change that formula. i guess what i'm trying t
say is that i don't want to make b1 a variable. thanks again for al
the help and your time.

Darrel
 
D

darrelly

PS - that sample sheet you sent really helps! Thanks! I just got t
figure out how to remove the b1 and c1 cells as variables and mak
them a set amount
 
M

Max

.. remove the b1 and c1 cells as variables and make them a set amount.

For the same set-up, maybe just put instead in B2 as:
=INDIRECT("'"& TRIM($A$1) &" "& TRIM($A2) & "'!A1")
and copy down
 
Top