Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-Column Drop-down list ?
How can I create a multiple (6)column drop-list, so when I make a selection
from the list in the far left (1st)column, the cells across the remaining (5)columns will be populated. The drop-down list should be flexible to allow additions and deletions, the third column in the drop-down list should allow variable entries and blank cells. The data in each column can be text and numerical. The list may contain several hundred rows, across the (5) columns. Regards, JB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi-Column Drop-down list ?
Hi JB,
As a starting point, see Debra Dalgleissh's Dependent Lists page at: http://www.contextures.com/xlDataVal02.html See also xlDynamics Dependent Dropdowns page at: http://www.xldynamic.com/source/xld.Dropdowns.html --- Regards, Norman "JB" wrote in message ... How can I create a multiple (6)column drop-list, so when I make a selection from the list in the far left (1st)column, the cells across the remaining (5)columns will be populated. The drop-down list should be flexible to allow additions and deletions, the third column in the drop-down list should allow variable entries and blank cells. The data in each column can be text and numerical. The list may contain several hundred rows, across the (5) columns. Regards, JB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
re-ordering the list on a filter drop down | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
circular drop down list on different pages | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
drop down list multiple columns | Excel Discussion (Misc queries) |