Hey all,

I am attempting to automate a file as much as possible and this
includes commentary at the end of the excel sheet. I was wondering if
there is a function or set of functions that will allow me to have a
text string with a link to a number within that string.

For example:

I work (X) days a week. in Cell A1, lets say. And have that (X) be a
link to cell B2 which contains a number in it.
THis way the text is static and only the numbers autoupdate based upon
the linkage.

Any way to do this? Thanks so much in advance for your help!

-Pogster

I think you could use INDIRECT for this, but it is not that clear from
your description, so could you post a bit more detail? (I seem to
remember asking this before !!)

Pete

On Nov 27, 3:07 pm, wrote:
Hey all,

I am attempting to automate a file as much as possible and this
includes commentary at the end of the excel sheet. I was wondering if
there is a function or set of functions that will allow me to have a
text string with a link to a number within that string.

For example:

I work (X) days a week. in Cell A1, lets say. And have that (X) be a
link to cell B2 which contains a number in it.
THis way the text is static and only the numbers autoupdate based upon
the linkage.

Any way to do this? Thanks so much in advance for your help!

-Pogster

In A1 enter:

="I work "&B1&" days a week."

Enter a number in B1.
--
HTH,

RD

----------------------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
----------------------------------------------------------------------------------------

wrote in message
...
Hey all,

I am attempting to automate a file as much as possible and this
includes commentary at the end of the excel sheet. I was wondering if
there is a function or set of functions that will allow me to have a
text string with a link to a number within that string.

For example:

I work (X) days a week. in Cell A1, lets say. And have that (X) be a
link to cell B2 which contains a number in it.
THis way the text is static and only the numbers autoupdate based upon
the linkage.

Any way to do this? Thanks so much in advance for your help!

-Pogster

Yup, thats exactly what i was looking for. I knew there had to be an
easy solution. Thanks for the solution Ragdyer, and Pete for your
attention!

-pogster

With Ragdyer's solution, I can see what you wanted now - he must be
better at mind-reading than I am !! <bg

Pete

On Nov 27, 6:30 pm, wrote:
Yup, thats exactly what i was looking for. I knew there had to be an
easy solution. Thanks for the solution Ragdyer, and Pete for your
attention!

-pogster

Thanks for the feed-back.

And Pete ... you have made many correct suggestions to posts that I didn't
even bother to respond to because I couldn't understand them.

Sometimes ... things just "click" ... or the guess turns out right.<g
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

wrote in message
...
Yup, thats exactly what i was looking for. I knew there had to be an
easy solution. Thanks for the solution Ragdyer, and Pete for your
attention!

-pogster