Formula
 

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

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

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

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