Help required

%3CLINGO-SUB%20id%3D%22lingo-sub-2452472%22%20slang%3D%22en-US%22%3EHelp%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2452472%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20creating%20a%20distribution%20matrix%20for%20work%20and%20I%20wanted%20to%20know%20if%20instead%20of%26nbsp%3Bhaving%20a%20long%20list%20like%20the%20in%20the%20attachment.%20Can%20I%20have%20a%20drop%20down%20menu%20where%20you%20pick%20the%20specific%20submission%20and%20it%20populates%20the%20columns.%20Hope%20this%20makes%20sense.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2452472%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2455881%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2455881%22%20slang%3D%22en-US%22%3EThe%20short%20answer%20is%20Yes.%3CBR%20%2F%3EThe%20long%20answer%20is%20that%20more%20information%20is%20needed%20to%20assess%20what%20it%20is%20you%20want%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2455984%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20required%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2455984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1080101%22%20target%3D%22_blank%22%3E%40billyrichrich83%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20%3CU%3E%3CSTRONG%3EStoneKiwi%3C%2FSTRONG%3E%3C%2FU%3E%20has%20already%20said%2C%20you'll%20need%20to%20provide%20quite%20a%20bit%20more%20information%20in%20order%20to%20get%20more%20than%20general%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20fact%2C%20although%20you%20seem%20to%20think%20there's%20an%20obvious%20%22long%20list%22%20in%20your%20attachment%2C%20I%20don't%20see%20one%20that%20would%20qualify%20as%20that.%20So%20if%20there%20is%20in%20that%20attachment%20a%20%22long%20list%22%20that%20you%20want%20to%20use%20as%20the%20source%20for%20a%20drop%20down%20please%20let%20us%20know%20what%20it%20is.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecond%2C%20you've%20already%20put%20a%20lot%20of%20work%20into%20making%20this%20workbook%20look%20nice.%20If%20I%20can%20offer%20a%20suggestion%3A%20your%20first%20priority%20in%20designing%20a%20workbook%20in%20Excel%20is%20to%20make%20it%20functional.%20There%20are%20many%20times%20when%20I've%20witnessed%20a%20really%20%22pretty%22%20spreadsheet%20which%20still%20isn't%20functional%2C%20and%20even%20times%20when%20the%20use%20of%20combined%20cells%20and%20other%20fancy%20formatting%20features%20%3CSTRONG%3Egets%20in%20the%20way%3C%2FSTRONG%3E%20of%20functionality.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you're%20interested%20in%20solving%20the%20drop-down%20on%20your%20own%2C%20do%20some%20research%20into%20Data%20Validation...%20here's%20a%20link%20that%20might%20get%20you%20started.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-data-validation-guide%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-data-validation-guide%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, 

 

Currently creating a distribution matrix for work and I wanted to know if instead of having a long list like the in the attachment. Can I have a drop down menu where you pick the specific submission and it populates the columns. Hope this makes sense.

2 Replies
The short answer is Yes.
The long answer is that more information is needed to assess what it is you want

@billyrichrich83 

 

As StoneKiwi has already said, you'll need to provide quite a bit more information in order to get more than general help.

 

In fact, although you seem to think there's an obvious "long list" in your attachment, I don't see one that would qualify as that. So if there is in that attachment a "long list" that you want to use as the source for a drop down please let us know what it is.

 

Second, you've already put a lot of work into making this workbook look nice. If I can offer a suggestion: your first priority in designing a workbook in Excel is to make it functional. There are many times when I've witnessed a really "pretty" spreadsheet which still isn't functional, and even times when the use of combined cells and other fancy formatting features gets in the way of functionality.

 

If you're interested in solving the drop-down on your own, do some research into Data Validation... here's a link that might get you started. https://exceljet.net/excel-data-validation-guide