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