Cell Reference

[Pinda]

I have certain IDs for directorates

eg.

Cl = Clinical
CS = Clinical Services
F&PM - Finance & Performance Management

I have these IDs in a list on a spreadsheet and they come
from an array from a separate spreadsheet.

What I want to do is to add something that denotes Cl
refers to Clinical Services for people using the
spreadsheet that do not know what ID codes refer to. This
way they do not need to switch to the directorates
spreadsheet to find out that Cl = Clinical. I can use a
lookup next to the ID code but it wastes too much space.

Is this possible with some sort of note that refers to
this array and brings up the correct meaning for a
particular ID code?

Please advise I would be very grateful.

Pinda

 

[Ashish Mathur]

Hi,

I hope i have understood your question correctly. Go to
the abbreviated cell and then Goto > Insert > Comment.
Type the full form there. Now whenever, the mouse is
taken over the cell, the note appears.

Regards,

Ashish Mathur
Excel - MVP

 

[Pinda]

Thanks for your help.

I knew about that one, but I was just wondering if the
comment brings up just the Reference for that cell.

eg. Cl would bring up jus Clinical rather than the whole
list?

Any ideas? Is it possible with the use of VBA?

Thanks.