| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
dynamic cell reference within a text string
The documentation of my model includes a text string typed into a cell to the
effect "alter the conversion factor, ie cell D23, to etc etc". My problem is that as the model develops, the cell containing the conversion factor changes, ie the reference to D23 becomes wrong. Is there a way of referring to D23 in the aforementioned text string so that the cell reference changes in sync with changes to the cell containing conversion factor? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| dynamic external cell reference | Excel Worksheet Functions | |||
| How to make a cell return the formatted value in a text string (i. | Excel Worksheet Functions | |||
Threaded Mode
