Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
substitute the filename in a cell reference with a string in another cell. | Excel Discussion (Misc queries) | |||
Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
dynamic cell reference within a text string | Excel Worksheet Functions | |||
How to get a cell reference of by searchig a text string? | Excel Discussion (Misc queries) |