Link or Cell Reference Within Text String

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
 
P

Pete_UK

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
 
P

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
 
P

Pete_UK

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

Pete
 
R

RagDyeR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top