Dynamic formulas including worksheet references
 

Hi,

I have the following "minor" headache:

I have on one summary worksheet different company names in rows with
their corresponding key figures (formulas) in the columns. Every
company has a corresponding worksheet, that is named after the company
(done automatically with a macro.) My question would be if it is
possible to have the following formula/reference in the individual
colums:

company A =Worksheet of company A $A$1

company B = Worksheet of company B $A$!


that I could basically copy down every column and which would take the
worksheet reference from the column with the company names.

Cheers

Lars


--
lars22222
------------------------------------------------------------------------
lars22222's Profile: http://www.excelforum.com/member.php...o&userid=25603
View this thread: http://www.excelforum.com/showthread...hreadid=390167

=INDIRECT(A1&"!$A$1")

--
HTH

Bob Phillips

"lars22222" wrote
in message ...

Hi,

I have the following "minor" headache:

I have on one summary worksheet different company names in rows with
their corresponding key figures (formulas) in the columns. Every
company has a corresponding worksheet, that is named after the company
(done automatically with a macro.) My question would be if it is
possible to have the following formula/reference in the individual
colums:

company A =Worksheet of company A $A$1

company B = Worksheet of company B $A$!


that I could basically copy down every column and which would take the
worksheet reference from the column with the company names.

Cheers

Lars


--
lars22222
------------------------------------------------------------------------
lars22222's Profile:
http://www.excelforum.com/member.php...o&userid=25603
View this thread: http://www.excelforum.com/showthread...hreadid=390167