You're welcome.
Thanks for the feed-back.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Pete Bodie" wrote in message
...
It works great. What a time saver this going to be.
Thank You
"RagDyeR" wrote:
Try this:
=INDIRECT("daily"&A2&"!C5")
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Pete Bodie" <Pete wrote in message
...
I would like to create a formula in a cell that uses the value from
another
cell to compleat the formula.
Formula in A1 =daily[value from A2)!c5 Where A2 is 01
Finished formula would be =daily01!c5
Is this possible