The simplest way is to use Data Validation (Option "List") in cell B2
and retrieve the data in cells B3, B4, etc. with VLOOKUP functions.
You can take a look to this post:
http://jldexcel.blogspot.com/2006/02...xcel-data.html
--
jordun
------------------------------------------------------------------------
jordun's Profile:
http://www.excelforum.com/member.php...o&userid=33118
View this thread:
http://www.excelforum.com/showthread...hreadid=530698