Thread
:
Calculating using data from another worksheet
View Single Post
#
2
Frank Kabel
Posts: n/a
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
Reply With Quote