on a separate sheet I created a list of items and I named it company,
then on the first sheet I created box called company and went to data »
validation and chose allow for: list and linked the drop-down to my list
of items on the other sheet.


--
MarcB
------------------------------------------------------------------------
MarcB's Profile: http://www.excelforum.com/member.php...o&userid=14988
View this thread: http://www.excelforum.com/showthread...hreadid=278300