Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 26th 05, 04:01 PM posted to microsoft.public.excel.misc
JB
 
Posts: n/a
Default 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   Report Post  
Old December 26th 05, 06:30 PM posted to microsoft.public.excel.misc
Norman Jones
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
re-ordering the list on a filter drop down Kylor Excel Discussion (Misc queries) 3 December 19th 05 06:59 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
circular drop down list on different pages Cbh35711 Excel Worksheet Functions 0 August 16th 05 06:11 PM
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
drop down list multiple columns c Excel Discussion (Misc queries) 9 January 27th 05 03:13 PM


All times are GMT +1. The time now is 08:04 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017