Hi all

I have a large worksheet and one column contains a code consisting of two
letters. The two letters represent the name of a particular division
Division. For example, FG would mean 'Food Group', HR would mean
'Healthcare'.

As there are too many for me to remember what they all mean, is there a way
I can click onto a cell and Excel gives me an 'input message' style box,
telling me what the code stands for?

I have tried to use Data Validation but can't get that to work as it shows
the same input message regardless of what cell I am on.

By the way, the worksheet is sorted in numerical order by another column so
I can't sort it by the Code and then apply separate input messages.

Does anybody have any other ideas???

Thank you.

Louise