excel combobox
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 |
excel combobox
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 |
excel combobox
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 |
excel combobox
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 |
All times are GMT +1. The time now is 10:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com