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

One alternative is to use the VLookup function to look up the values on the
hidden sheet for each location.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


"Sandor" wrote in
message ...

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

It works great David, thank you

--
Sando
-----------------------------------------------------------------------
Sandor's Profile: http://www.excelforum.com/member.php...fo&userid=2700
View this thread: http://www.excelforum.com/showthread.php?threadid=40711