Chris

This can generally be done by use of a VLOOKUP formula once a table has been
set up.

For more on VLOOKUP see Help or go to Debra Dalgleish's site for a great
tutorial and a downloadable example workbook.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 07:30:10 -0800, "Chrisj20"
wrote:

I regularly run reports which produce a column of staff by reference to their
code number which I have to manually change to their initials. Is there a way
of doing this automatically or by running a macro.

Thanks anyone.