drop down selects
Hello,

I currently have a drop down box which list location names. The problem
is the location names are very generic (only part of the location info).
What I would like to do is have a drop down list actually list the full
location name but populate the field with the generic name when
selected. I could add another column but this file will be used as
import data and the extra field is not part of the extract layout.

Ex.

Generic name:T100

Full location name: Trumbull 100 (specific trumbull address)

User's would select trumbull 100 from the drop down list, but the name
T100 would actually populate the field. I tried to reference the
generic range but keep on getting a circular reference error. Can this
be done?


--
pyarb
------------------------------------------------------------------------
pyarb's Profile: http://www.excelforum.com/member.php...o&userid=26803
View this thread: http://www.excelforum.com/showthread...hreadid=400570