excel combobox

[Bagpuss]

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 Ogilvy]

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

 

[Bagpuss]

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

 

[Gord Dibben]

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