Link or Cell Reference Within Text String

  • Thread starter Thread starter pogster
  • Start date Start date
P

pogster

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
 
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
 
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 !
-----------------------------------------------------------------------------------------------

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
 
Back
Top