Select Multiple Items from Excel Data Validation List

http://www.contextures.com/excelfiles.html#DV0017 Select multiple items from Excel drop down list, and show them in the same cell, separated by commas, or in another column or row.

Category:

Science & Technology

Tags:

• Excel
• Contextures
• data validation
• Excel data validation

[MurseBry]

I like the CommaSeperated one is there a way to download this spreadsheet so I can take a look at the VBA code ?

I would be interested in the CommaSeperated one in a dataForm. Is it possible to do that ?

[contextures]

@MurseBry Click the link in the Video description, and you can download the sample file from my Contextures website.

[KhaledKhozamy]

do you know how to extract data in Columns A B C D when A is your lead and make data ( text ) in the columns b s d move to another sheet in rows under each other

I wanna make a drop down menu for list of data in A column and then once i select it it rank in rows under each other

[contextures]

@KhaledKhozamy No, I don't have an example that does that. You could ask in one of the Excel forums and someone might be able to help.

[edwlee78]

Very useful (potentially for something I've been tasked with). Thank you!

[contextures]

@edwlee78 You're welcome! Glad the video helped you.

[pink2ply]

thank you so much for this! very helpful- especially the downloadable sheet which has comments on the spreadsheet.

[JillianConvey]

So useful thank you!!

[snarrak]

Very nice video!! Is there a code rule that checks if the value isn't already in the cell?

[serdomingues]

Great tutorial! The perfect answer to a problem I had, but...is it possible to change the code to allow the "SameCellAddRemove" for multiple columns? I know litlle about VBA... :)