How can I use a combobox to select 1 row with 5 colums data from a seperate
worksheet containing over 100 rows of data and populate 5 cells on current
sheet? Ideally would like to detect number of rows of data automatically to
cope with different lists

http://www.contextures.com/xlDataVal01.html
the basics

http://www.contextures.com/xlDataVal05.html
to get a list from another workbook or another worksheet


http://www.contextures.com/xlFunctions02.html
How to pull in related data based on a key data element value

--
Regards,
Tom Ogilvy



"Bagpuss" wrote:

How can I use a combobox to select 1 row with 5 colums data from a seperate
worksheet containing over 100 rows of data and populate 5 cells on current
sheet? Ideally would like to detect number of rows of data automatically to
cope with different lists

Tom

Dynamic list works fine, but still unclear how to select multiple columns of
data from a drop down list eg with names and addresses, if select name with
data validation can I also populate cells with relevant address details?
Using Office 2003

"Tom Ogilvy" wrote:


http://www.contextures.com/xlDataVal01.html
the basics

http://www.contextures.com/xlDataVal05.html
to get a list from another workbook or another worksheet


http://www.contextures.com/xlFunctions02.html
How to pull in related data based on a key data element value

--
Regards,
Tom Ogilvy



"Bagpuss" wrote:

How can I use a combobox to select 1 row with 5 colums data from a seperate
worksheet containing over 100 rows of data and populate 5 cells on current
sheet? Ideally would like to detect number of rows of data automatically to
cope with different lists

You need a lookup table and the use of VLOOKUP function in cells adjacent to the
DV dropdown list.

See Debra's site for help on VLOOKUP

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 15:36:01 -0700, Bagpuss
wrote:

Tom

Dynamic list works fine, but still unclear how to select multiple columns of
data from a drop down list eg with names and addresses, if select name with
data validation can I also populate cells with relevant address details?
Using Office 2003

"Tom Ogilvy" wrote:


http://www.contextures.com/xlDataVal01.html
the basics

http://www.contextures.com/xlDataVal05.html
to get a list from another workbook or another worksheet


http://www.contextures.com/xlFunctions02.html
How to pull in related data based on a key data element value

--
Regards,
Tom Ogilvy



"Bagpuss" wrote:

How can I use a combobox to select 1 row with 5 colums data from a seperate
worksheet containing over 100 rows of data and populate 5 cells on current
sheet? Ideally would like to detect number of rows of data automatically to
cope with different lists