LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Cell reference within text?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find cell with matching text, then reference cell in same row [email protected] Excel Worksheet Functions 2 October 20th 07 01:05 AM
Making cell reference absolute makes cell format text Excel Worksheet Functions 2 September 22nd 06 04:47 PM
How do I put text and a cell reference in a text box? Sarah Lefevre Excel Discussion (Misc queries) 3 September 15th 06 12:57 PM
Cell only shows link in text, not contents of reference cell Jay Mac New Users to Excel 4 August 23rd 05 08:36 PM
How can I reference data or text within a text box to a cell in Ex BB Excel Discussion (Misc queries) 2 January 25th 05 07:55 PM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"