Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
clicking cell containing text, and a numeric value appear in anoth
need to click on a cell with a text entry and somehow hyperlink its answer so
that it appears in another cell as a numeric value, I have the all the numeric values stored. eg, Thames Water 12 (Click Thames Water) (numeric value appears) The numeric values can be shown and stored on the same document if this helps or alternatively they can be filed anywhere. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
clicking cell containing text, and a numeric value appear in anoth
If the list is not too long, use Data Validation to select the text and use
VLOOKUP to find the value corresponding the the selected text. Is this an acceptable solution? I believe your requested solution will require a VBA macro to achieve it. "Graham Allen" wrote: need to click on a cell with a text entry and somehow hyperlink its answer so that it appears in another cell as a numeric value, I have the all the numeric values stored. eg, Thames Water 12 (Click Thames Water) (numeric value appears) The numeric values can be shown and stored on the same document if this helps or alternatively they can be filed anywhere. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
wrap text function causes data to disappear in cell (visually only | Excel Discussion (Misc queries) | |||
Format cell conditional numeric and text | Excel Discussion (Misc queries) | |||
Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
Text not wrapping within a cell | Excel Discussion (Misc queries) | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) |