dynamically referencing to another worksheet

Hi all,

I'm relatively new to Excel but I'm working on a spreadsheet for work.
Let's say I have a workbook with a separate tab (worksheet) called
"exam1". On the first worksheet I can reference to a cell (let's say
A2) in the other by using "=exam1!A2".

Here's what I need to do though. On the first worksheet in column A, I
will have a list of all the tabs that will eventually be included in
the spreadsheet (e.x. A1 = exam1, A2 = exam2, A3 = exam3, etc.). Is
there a way I can modify the code from the first worksheet above
(=exam1!A2) to be dynamic? Something like "=A1!A2" is what I had in
mind, but that syntax doesn't work. Anyone have any ideas?

Thanks in advance.

Have a look in the help index for INDIRECT

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"D23" <Destroyer23@gmail.com> wrote in message
news:1151068220.955903.208590@r2g2000cwb.googlegroups.com...
> Hi all,
>
> I'm relatively new to Excel but I'm working on a spreadsheet for work.
> Let's say I have a workbook with a separate tab (worksheet) called
> "exam1". On the first worksheet I can reference to a cell (let's say
> A2) in the other by using "=exam1!A2".
>
> Here's what I need to do though. On the first worksheet in column A, I
> will have a list of all the tabs that will eventually be included in
> the spreadsheet (e.x. A1 = exam1, A2 = exam2, A3 = exam3, etc.). Is
> there a way I can modify the code from the first worksheet above
> (=exam1!A2) to be dynamic? Something like "=A1!A2" is what I had in
> mind, but that syntax doesn't work. Anyone have any ideas?
>
> Thanks in advance.
>

Try this:

=INDIRECT("'"&A1&"'!A2")

and copy down as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"D23" <Destroyer23@gmail.com> wrote in message
news:1151068220.955903.208590@r2g2000cwb.googlegroups.com...
Hi all,

I'm relatively new to Excel but I'm working on a spreadsheet for work.
Let's say I have a workbook with a separate tab (worksheet) called
"exam1". On the first worksheet I can reference to a cell (let's say
A2) in the other by using "=exam1!A2".

Here's what I need to do though. On the first worksheet in column A, I
will have a list of all the tabs that will eventually be included in
the spreadsheet (e.x. A1 = exam1, A2 = exam2, A3 = exam3, etc.). Is
there a way I can modify the code from the first worksheet above
(=exam1!A2) to be dynamic? Something like "=A1!A2" is what I had in
mind, but that syntax doesn't work. Anyone have any ideas?

Thanks in advance.