Thanks Biff, I got it to work now. I have been looking for the function in
excel which acts like formula in VBA for a long time. Thanks again.
"Biff" wrote:
Hi!
Are you using the R1C1 reference style?
Assume R1C1 (A1) = Quality
=INDIRECT(R1C1&"!R2C2",FALSE)
Evaluates to:
=Quality!B2 (R2C2)
Biff
"Micah" wrote in message
...
I have the same question, but instead of "mmm yy" I want to referene a
cell
with the word "Quality" in it. I then want to concatenate that cell with
R2C2 such that I get a formula =Quality!R2C2.
I tried the formula below with the cell for Quality in the text function
with no formating after the , i.e. text(r1c1, ) and could not get it to
work.
Your help would be appreciated.
"tony h" wrote:
Thank you for your help.
A bit of playing about (and the function you so kindly pointed out)
gives =INDIRECT("'" & TEXT(A4,"mmm yy") & "'!$C$3",TRUE)
without the TEXT function it brought in the date serial number, and the
sum function is : =SUM(INDIRECT("'"&TEXT(A4,"mmm
yy")&"'!$C$6:C40",TRUE))
Many thanks
--
tony h
------------------------------------------------------------------------
tony h's Profile:
http://www.excelforum.com/member.php...o&userid=21074
View this thread:
http://www.excelforum.com/showthread...hreadid=392470