We have a _user_account_request_form_ for our end users, where they can
select their *location* from a predefined list. Now I'd like the
address, zip, city etc. to be filled from that also.

On the default _Request_sheet_, there is field 'Local office' (D37). On
the (hidden) _Locations_sheet_ are all locations, one per row, with
fields like address, zip, city etc.
On D37 I did 'Data/Validation/Settings/Source=Location' which is the
defined name for all fields in column A of the Locations sheet. This
column has all location names.

But I'd like also some other fields from the same row (of a certain
location) to be presented in the Request sheet when a location is
selected. On the Request sheet, I already made fields like 'Address'
and 'City', but I don't know how to proceed. Does anybody know a
solution?


--
Sandor
------------------------------------------------------------------------
Sandor's Profile: http://www.excelforum.com/member.php...o&userid=27006
View this thread: http://www.excelforum.com/showthread...hreadid=407111