Calculating using data from another worksheet

S

Sid N

Hello,

Is there a way wherein i can use a variable name, whose value is a
worksheet name, in a calculation? I do not want to hard-code the name of the
worksheet into the formula. I want to pick up the name from the value of a
cell.

Thanks
Sid N
 
F

Frank Kabel

Hi
if A1 contains the worksheet name try:
=INDIRECT("'" & A1 & "'!X1")
to return cell X1 from this sheet
 
Top