Use of the Contents of a cell as a worksheet name in a function
 

How does one use the contents of a cell to contain the name of a worksheet
and then use those contents in a formuala...

e.g.
A1 = separate worksheet name
A2 = contents of (separate worksheet name!A2)
A3 = contents of (separate worksheet name!A3)
etc. etc... ( like to use fill down from here)

Played with indirect for awhile but I am missing something...

Use of the Contents of a cell as a worksheet name in a function
 

Try this in A2:

=INDIRECT("'"&A$1&"'!A"&ROWS($1:2))

Copy down as needed

--
Biff
Microsoft Excel MVP


"tooMuchFun" wrote in message
...
How does one use the contents of a cell to contain the name of a worksheet
and then use those contents in a formuala...

e.g.
A1 = separate worksheet name
A2 = contents of (separate worksheet name!A2)
A3 = contents of (separate worksheet name!A3)
etc. etc... ( like to use fill down from here)

Played with indirect for awhile but I am missing something...

Use of the Contents of a cell as a worksheet name in a functio
 

Thank you... works like a champ

"T. Valko" wrote:

Try this in A2:

=INDIRECT("'"&A$1&"'!A"&ROWS($1:2))

Copy down as needed

--
Biff
Microsoft Excel MVP


"tooMuchFun" wrote in message
...
How does one use the contents of a cell to contain the name of a worksheet
and then use those contents in a formuala...

e.g.
A1 = separate worksheet name
A2 = contents of (separate worksheet name!A2)
A3 = contents of (separate worksheet name!A3)
etc. etc... ( like to use fill down from here)

Played with indirect for awhile but I am missing something...

Use of the Contents of a cell as a worksheet name in a functio
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"tooMuchFun" wrote in message
...
Thank you... works like a champ

"T. Valko" wrote:

Try this in A2:

=INDIRECT("'"&A$1&"'!A"&ROWS($1:2))

Copy down as needed

--
Biff
Microsoft Excel MVP


"tooMuchFun" wrote in message
...
How does one use the contents of a cell to contain the name of a
worksheet
and then use those contents in a formuala...

e.g.
A1 = separate worksheet name
A2 = contents of (separate worksheet name!A2)
A3 = contents of (separate worksheet name!A3)
etc. etc... ( like to use fill down from here)

Played with indirect for awhile but I am missing something...