Thanks for the prompt reply Jan Karel
I had a look at it but don't quite understand. Could you please give me an
example of how this can be done?

Thanks

"Jan Karel Pieterse" wrote:

Hi Greenback,

Would it be possible in Cell B1 to create a list from 1950 -
1990 and be able to choose a relevant year and the choice made will show in
cell B1?

Data, Validation is what you're after!

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com