Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
I am creating a fairly extensive group of sheets that reference a data table at the start of the workgroup. I have to do some descriptive text within the sheet and have to reference the cells holding the "percentage" for instance. This percentage will change from time to time and i would like the descriptive text to be the same but reflect the percentage change only. Currently i have worded it so i can place the descriptive text in one cell and the percentage in the adjoining cell but this is becomming more difficult for formatting. I am assuming that there is some way to create something like a hyperlink to refer to the cell but the link won't display a change only that there is a link. This will be printed as a final version and there will be no opportunity for the reader to click anything. Suggestions appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find cell with matching text, then reference cell in same row | Excel Worksheet Functions | |||
Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
How do I put text and a cell reference in a text box? | Excel Discussion (Misc queries) | |||
Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
How can I reference data or text within a text box to a cell in Ex | Excel Discussion (Misc queries) |