I have created drop down menus before but I never created a drop down menu in another cell BASED on the value they chose from another cell. Thank you. Your video taught me EXACTLY how to do that. Easy to follow you.
Is it possible to creat a search option in top of the drop down list? If I have a list with 100 different options, it takes a long time to find the correct one if I have to sort through them manually. With a serarch option it would be a lot easier. thx. in advance
Is there a way to validate the data being dynamically pulled to prevent repeats on your drop down list? Let's say you listed Dell twice, wouldn't it show up twice in your drop down list? Is there a way to test and filter out repeat entries from showing up in the drop down?
Is there a way to title-name the actual drop-down menu? Like say. Computer Manufacturers and then select from Compaq, Mac, Dell etc as in the example shown? Or do I just Name the cell on top of the drop-down menu and that's it? Also if I wanted to export the data as if it was all entered manually with no drop downs, could I do that? Just trying to create a GUI database from an excel sheet. Tnx.
Thank you for this lesson. But i have a problem. I get no list when i type the list words consecutively with a comma. I use excel 2016, maybe there is a different ?
I've found that if you're creating the dropdown list in a macro, use a comma to separate the values. Use the semi-colon if you're adding it directly into the sheet. In case anyone finds that useful.. :)
Ok, but what about the next step? The value or the comment of the selected item from the drop down menu? How to link this with that? How to get sub menu for more options?
For some reason by specifying the list separated by commas I obtaing in the drop down menu a unique string 'January, February, March, April, May' and no other options in the drop down. Is there anything I'm doing wrong?
It's a good tutorial, but my background colors for my cell formatting does not show up. The cell's backgrounds remain white. How do you add background colors to work books that will show up when added to the main page?
Yeah, just select that column and under the same tab "Data" click Remove Duplicates. It will remove the 2nd Dell entry. There's no need to mess with the Data Validation.
Is there a limit on the amount of items inserted on the drop down list? I am creating a drop down list and excel is not allowing me to add any more items
I have created drop down menus before but I never created a drop down menu in another cell BASED on the value they chose from another cell. Thank you. Your video taught me EXACTLY how to do that. Easy to follow you.
One of the best video's, and the best way of teaching 👍
Explanation was very precise and clear. Thanks Giridhar
So simple, I watched 5 other videos before I found this one, none really simply answered the question. Thank you !
Thank you! That was so much simpler than any other video.
Thank You!! That makes so much more sense than the "Help" instructions in Excel!
Thanks. Simple and to the point. Nice job !!!
Thanks. Got right to the point for what I needed. Quick and easy. =)
Thanks for posting that. Works in Excel 2008 on Mac as well.
What do you do if you need select multiple selection from dropdown menu?
Can it work if I use a filter on the same sheet too (or even the same spreadsheet). As I'm using 2010
Is it possible to creat a search option in top of the drop down list? If I have a list with 100 different options, it takes a long time to find the correct one if I have to sort through them manually. With a serarch option it would be a lot easier.
thx. in advance
I just want to ask, is it possible to delete the text in Column E and what is encoded in the drop-down menus (Column A) remain?
Wow! Awesome tutorial! Short and sweeeet! Thank you!!
Gracias! Buen video! Corto y explicativo.
Extremely helpful, quick and to the point. Thanks!
Thank you very helpful and easy to fallow. I have tried others and always seem to miss something.
I learnd a lot
Fabulous explanation!
Great vid. Short and to the point.
drop downs are so important we use them all the time for fitness and strength and conditioning programs
Is there anyway that you can create a drop down list by selected specific cells e.g. A1, A3, A5 instead of selecting all the cells?
thanxs man, been looking how to do this for a long time!
Nice and short. Very well done and helpful.
Is there a way to validate the data being dynamically pulled to prevent repeats on your drop down list? Let's say you listed Dell twice, wouldn't it show up twice in your drop down list?
Is there a way to test and filter out repeat entries from showing up in the drop down?
thanks that was easy to understand and we were able to understand you when you spoke
Is there a way to title-name the actual drop-down menu? Like say. Computer Manufacturers and then select from Compaq, Mac, Dell etc as in the example shown? Or do I just Name the cell on top of the drop-down menu and that's it? Also if I wanted to export the data as if it was all entered manually with no drop downs, could I do that? Just trying to create a GUI database from an excel sheet. Tnx.
Say you had drop downs for the months in an expense sheet. How would you then automatically add the expenses for an entire month?
Thank you for this lesson. But i have a problem. I get no list when i type the list words consecutively with a comma. I use excel 2016, maybe there is a different ?
Exactly what i wantend to know. Also very clear. I Thank you very much for telling me How to do this.
Who's still watching this in 2019
Thank you. This was helpful !
Finally. i found what i need to learn. from the scratch. Thank sir! ^_^
I've found that if you're creating the dropdown list in a macro, use a comma to separate the values. Use the semi-colon if you're adding it directly into the sheet. In case anyone finds that useful.. :)
Thank you, indeed. A very clear explanation!
Thank you!!! You just saved me a hour!
Very simple and helpful.
Thank you, So helpful.
Can We Lock the folder of dropbox or any file at 2 or 3 places
Great job! Thanks very much!
Very nicely described!
Thank you very much. Very straight forward
Thank you very much for this helpful guide. It's something I'm able to implement at work. Awesome!
Thanks, very useful and strieght to the point
Thank you so much, very easy and clear
Very simple and helpful. Thank u sir
Supper explanation and very helpful
greate idia can you explain me in reverse order of what you created, like how to take selected data out of list and make it appear in regular cell
Thank you... I definitely needed this information for work today
Ok, but what about the next step? The value or the comment of the selected item from the drop down menu? How to link this with that? How to get sub menu for more options?
thank you , cleared and easy to learning .
Thanks a lot...it helps me alot
ok how do we make the dropdown list show data when selected ie if i select dell the other cells show specs or available models for the manufacturer
Nice Explanation as compared to other videos on the same topic from Different people. Thanks
very useful video, thanks a lot.
Proper jedi video - stonking quick tutorial!! Many thanks!
Very useful, thanks!
is it possible to get the source from another sheet of the excel?
Very helpful..... thank you
You are a life savers! I was racking my brain to trying to figure out!
Thanks you helped me alot
Very well done! Much appreciated.
For some reason by specifying the list separated by commas I obtaing in the drop down menu a unique string 'January, February, March, April, May' and no other options in the drop down. Is there anything I'm doing wrong?
Whoa!!! Awesome lecture.
Thank you very much, this was very helpful.
Exactly what I needed. Thanks.
It's a good tutorial, but my background colors for my cell formatting does not show up. The cell's backgrounds remain white. How do you add background colors to work books that will show up when added to the main page?
What with i wish to add the drop down list after sometimes without affecting other inputs that were inserted earlier?
Thanks. It worked for me!!!
This was very helpful. Thank you!
This was so easy, thank you
Waoo Waoo so easy to understood thank you.
Very helpfull thanks very much, I'm using Office 2010 and I works if you put ";" instead of a "," in case anyone is having that problem.
+Cris Parra Marti (Fish) Thanks!
Yeah, just select that column and under the same tab "Data" click Remove Duplicates. It will remove the 2nd Dell entry. There's no need to mess with the Data Validation.
Thanks for the great tips
Thank sir. Today i learned good to know.
Thanks for this tutorial. I learned something new.
This was fantastic - THANKS!
Very helpful! Thanks
Simple and useful!
Thank you for this video....!! 😊😊
Thank you very much and God bless you.
Thank you so much it was very help full for me..
Thank u very muchhh, I appreciate it!!!
Woow, really awesome 💙
I see the months which I seperate with koma in one line. What do I wrong?
thank you for this video....very useful one
great video thanks
thanks, this helped me a lot today
Just list them in cells somewhere on the spreadsheet and use the button on the source field to select them.
Thank you. Nice, clear & simple.
Thank you sir. I have got what in needed.
It's very helpful thank you very much
Is there a limit on the amount of items inserted on the drop down list? I am creating a drop down list and excel is not allowing me to add any more items
If you watch the second half of the video, you will be able to see how to add more.
Brilliant. Thank you sir!
thank you sir, this was really helpful
Thank you very much, a very helpful lesson
thanks i got it what i needed
THANK YOU VERY MUCH!
Thanks very helpful, I don't understand people who dislike this video