CRS,
Best place to learn about drop down lists if they were created using
Data Validation is found here.
http://www.contextures.com/xlDataVal01.html
If they were created using combo boxes (VBA stuff) go here.
http://www.contextures.com/xlDataVal10.html
HTH
--
Casey
------------------------------------------------------------------------
Casey's Profile:
http://www.excelforum.com/member.php...fo&userid=4545
View this thread:
http://www.excelforum.com/showthread...hreadid=469531