Data Validation Programming
 

Hello,

Using excel 97, I currently have a drop down box which list locatio
names. The problem is the location names are very generic (only part o
the location info). What I would like to do is have a drop down lis
actually list the full location name but populate the field with th
generic name when selected. I could add another column but this fil
will be used as import data and the extra field is not part of th
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 nam
T100 would actually populate the field. I tried to reference th
generic range but keep on getting a circular reference error. Can thi
be done

--
pyar
-----------------------------------------------------------------------
pyarb's Profile: http://www.excelforum.com/member.php...fo&userid=2680
View this thread: http://www.excelforum.com/showthread.php?threadid=40148