software

I need to dynamically reference sheets in excel and am having a hard
time doing it.

The most eligant solution i have is to use a prefab'd row to define my
sheets.

Here's what I mean:
A1 = quot;Item 1quot;
B1 = quot;Item 2quot; where quot;Item 1quot; and quot;Item 2quot; exactly match the names of
other sheets in my file.

I'd like to do something like
A2 = A1!B3
B2 = B1!B3

This way I can simply copy row two accross all the columns to extract
the data from various sheets and include them on a single page.

But I can't find the proper equation to make Excel recognize the
contents of row 1 as the actual sheet names.

Please help, this is driving me mad!!!--
patrickgamer
------------------------------------------------------------------------
patrickgamer's Profile: www.excelforum.com/member.php...oamp;userid=33918
View this thread: www.excelforum.com/showthread...hreadid=536962The INDIRECT function is what you're looking for. Writing the formlua so
that it will increment appropriately when copied, is a bit more tricky.
Something like this might work for you:

=INDIRECT($A1amp;quot;!quot;amp;ADDRESS(ROW(B$3),COLUMN(B$3)))

HTH,
Elkarquot;patrickgamerquot; wrote:

gt;
gt; I need to dynamically reference sheets in excel and am having a hard
gt; time doing it.
gt;
gt; The most eligant solution i have is to use a prefab'd row to define my
gt; sheets.
gt;
gt; Here's what I mean:
gt; A1 = quot;Item 1quot;
gt; B1 = quot;Item 2quot; where quot;Item 1quot; and quot;Item 2quot; exactly match the names of
gt; other sheets in my file.
gt;
gt; I'd like to do something like
gt; A2 = A1!B3
gt; B2 = B1!B3
gt;
gt; This way I can simply copy row two accross all the columns to extract
gt; the data from various sheets and include them on a single page.
gt;
gt; But I can't find the proper equation to make Excel recognize the
gt; contents of row 1 as the actual sheet names.
gt;
gt; Please help, this is driving me mad!!!
gt;
gt;
gt; --
gt; patrickgamer
gt; ------------------------------------------------------------------------
gt; patrickgamer's Profile: www.excelforum.com/member.php...oamp;userid=33918
gt; View this thread: www.excelforum.com/showthread...hreadid=536962
gt;
gt;