|
|
=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
|