How about a couple of examples?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"orcini" wrote in message
...
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.