Send me an example workbook and I will give it a go. Include what you want
to happen and where.


Regards,
Howard

"Angela9520" wrote in message
...
I would like to create a drop down list of number that, when selected, will
automatically fill out the the next cell with a name i.e.

I select No. 120 and the next cell automatically fills out the name as
being
Angela9520. How can I do that? Ostensible I want to select a number and
have the name associated with that number appear in the next cell!