Home

Searchable dropdown list in multiple cells from one source

%3CLINGO-SUB%20id%3D%22lingo-sub-848907%22%20slang%3D%22en-US%22%3ESearchable%20dropdown%20list%20in%20multiple%20cells%20from%20one%20source%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848907%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI'm%20looking%20to%20create%20a%20searchable%20dropdown%20list%20in%20each%20cell%20of%20a%20calendar%2C%20for%2010%20classes%2C%20roughly%202000%20dropdowns.%20At%20the%20moment%20I%20have%20non-searchable%20dropdowns%20in%20each%20cell%2C%20which%20means%20scrolling%20a%20long%20list%20of%20lessons%20to%20find%20the%20correct%20one%20-%20it%20would%20be%20much%20easier%20if%20I%20could%20type%20the%20first%20few%20letters%20of%20a%20lesson%20and%20select%20from%20the%20few%20matches%20than%20from%20the%20whole%20year's%20lessons.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThe%20problem%20is%20that%20all%20of%20the%20searchable%20solutions%20I%20have%20seen%20so%20far%20involve%20a%20column%20(or%20several)%20per%20dropdown%20list%2C%20e.g.%20in%20a%20hidden%20sheet.%20This%20is%20possible%20with%20much%20copy%20and%20paste%2C%20but%20hardly%20efficient%2C%20since%20each%20of%20the%202000%20odd%20tables%20I%20would%20need%20to%20create%20would%20need%20to%20mirror%20any%20changes%20to%20the%20original.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EIs%20there%20a%20simpler%20way%20to%20manage%20this%3F%20I%20am%20happy%20to%20take%20VBA%20solutions%2C%20though%20I'd%20rather%20avoid%20if%20I%20can.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20attached%20screenshots%20of%20the%20calendar%2C%20with%20one%20dropdown%20highlighted%20by%20the%20cursor%2C%20a%20dropdown%20in%20each%20box%2C%20and%20of%20the%20data%20tables%20they%20poll%20-%20as%20you%20can%20see%20quite%20sizeable!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CSPAN%3EAny%20suggestions%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131164i2939BDC8CBA1C2DE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20Prob.png%22%20title%3D%22Excel%20Prob.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-848907%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
thevicioushamster
Occasional Visitor

Hi,

I'm looking to create a searchable dropdown list in each cell of a calendar, for 10 classes, roughly 2000 dropdowns. At the moment I have non-searchable dropdowns in each cell, which means scrolling a long list of lessons to find the correct one - it would be much easier if I could type the first few letters of a lesson and select from the few matches than from the whole year's lessons.

The problem is that all of the searchable solutions I have seen so far involve a column (or several) per dropdown list, e.g. in a hidden sheet. This is possible with much copy and paste, but hardly efficient, since each of the 2000 odd tables I would need to create would need to mirror any changes to the original.

Is there a simpler way to manage this? I am happy to take VBA solutions, though I'd rather avoid if I can.

I have attached screenshots of the calendar, with one dropdown highlighted by the cursor, a dropdown in each box, and of the data tables they poll - as you can see quite sizeable!


Any suggestions?

 

ThanksExcel Prob.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies