display comments

L

Louis Charland

Here is what I am trying to achieve:

I have a large table whose cells either include much information or nothing
at all. Naturally, I don't want to display all the information in the table
because it gets too large. I want to mark all the cells having information
in them with an "R". As I click on any cell with an "R", the full content of
the cell is displayed in a large area on the top right on my spreadsheet. I
want every active "R" cell, to display its content in the same top right area.

How do I set this up?
 
L

Louis Charland

Thank you Norman,

What if I do not want to use codes. Instead, I want every "R" cell to
display a different content, i.e. an independant comment for each. Is that
possible?

Thanks
 
N

Norman Jones

Hi Louis,
What if I do not want to use codes. Instead, I want every "R" cell to
display a different content, i.e. an independant comment for each. Is that
possible?
Click to expand...

The codes are intended to provide a means to link a cell to its comment,
which is held on a separate worksheet. Without the code, how will the
appropriate comment be displayed. It would be feasible to use the cell's
address as the key, but, clearly, this would fail if rows or columns were
inserted in the main sheet.

Therefore, rather than using a simple 'R', try using R1, R2...Rn to
designate your comment cells. If you wish your users only to see the 'R',
why not set the font colour of the appended numeric to match the colour of
the cell background?
 
Top