ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multi-Column Drop-down list ? (https://www.excelbanter.com/excel-discussion-misc-queries/61878-multi-column-drop-down-list.html)

JB

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


Norman Jones

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





All times are GMT +1. The time now is 09:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com