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