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