L
lars22222
Hi,
I have the following "minor" headache:
I have on one summary worksheet different company names in rows wit
their corresponding key figures (formulas) in the columns. Ever
company has a corresponding worksheet, that is named after the compan
(done automatically with a macro.) My question would be if it i
possible to have the following formula/reference in the individua
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 th
worksheet reference from the column with the company names.
Cheers
Lar
I have the following "minor" headache:
I have on one summary worksheet different company names in rows wit
their corresponding key figures (formulas) in the columns. Ever
company has a corresponding worksheet, that is named after the compan
(done automatically with a macro.) My question would be if it i
possible to have the following formula/reference in the individua
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 th
worksheet reference from the column with the company names.
Cheers
Lar