I have an address list in one worksheet. I have a form in another worksheet
where I want to place a combo box that will allow me to select the person's
name and then fill in all the other columns with their address, phone number,
city, state, etc, on the form. Another vaariation of this is where I would
like to select the name of a person to go in that row and only have select
columns of information showing across the form (ex. I need name and address
but not birthday or spouse name). Does anyone know how do perform this
operation? I realize I can create this in Access, but my work computer does
not have MS Access installed.
Many thanks,
--
Russell Burke

Does this give you what you want?
http://www.contextures.com/xlDataVal13.html

Look here too.
http://www.contextures.com/xlDataVal10.html

regards,
Ryan---

--
RyGuy


"Burke" wrote:

I have an address list in one worksheet. I have a form in another worksheet
where I want to place a combo box that will allow me to select the person's
name and then fill in all the other columns with their address, phone number,
city, state, etc, on the form. Another vaariation of this is where I would
like to select the name of a person to go in that row and only have select
columns of information showing across the form (ex. I need name and address
but not birthday or spouse name). Does anyone know how do perform this
operation? I realize I can create this in Access, but my work computer does
not have MS Access installed.
Many thanks,
--
Russell Burke