Calculating using data from another worksheet
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Sid N" <Sid schrieb im Newsbeitrag
...
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