Thread
:
Using a Text Cell to Reference a Worksheet Name
View Single Post
#
3
February 28th, 2006, 01:57 AM posted to microsoft.public.excel.worksheet.functions
CLR
external usenet poster
Posts: n/a
Using a Text Cell to Reference a Worksheet Name
As an Example.....assume your data goes in columns B.....K
in cell A1 enter a sheet name
In B1 put this
=INDIRECT($A1&"!a1")
in C1 put this
=INDIRECT($A1&"!B1")...etc etc to get all 10 cells across Row 1
then in A2 put a new sheet name, and just copy and paste all 10 formulas
down to row 2
hth
Vaya con Dios,
Chuck, CABGx3
"Jay L" Jay
wrote in message
...
I have one summary worksheet and approximately 45 data worksheets. Each
row
on the summary page needs 8 - 10 cells from each data worksheet. The data
worksheets are identical in format. I add about 4 new data worksheets a
month.
I am tired of the tedious formula entry for each new worksheet, and would
like to have a way where i can enter the name of the new worksheet on the
summary page and all of the formulas on that row use the entered text name
to
reference the appropriate worksheet and cell.
Alas -- I have been unable to easily do this. I am still a relatively
junior excel user. Any ideas?
CLR
View message headers