Thank you, this is superb. I was able to follow along even though I have a much older version of Excel on a Mac. This is the best explanation I have found.

I created a very complex spreadsheet that accomplished exactly what you explained in the video, but your version was much more effective, less time-consuming, reduces formulas and thus file size. When I get back to work, I will begin to incorporate what I have learned here. THANK YOU SO VERY MUCH.

@ELKAMELBI

4 жыл бұрын

Jeff, man! You’re welcome, thanks for the feedback, really appreciate it. you made my day, glad I could help. Let me know if you have any questions.

This is the easiest tutorial i found on dependent drop down list without blanks! “Indirect” is way easier than “index”

Thank you Abdallah for showing how to do this practically. Great Job.! Helped me a lot.

@ELKAMELBI

4 жыл бұрын

You’re welcome Atul, glad you found it useful

This is Recommendable, its Going to help me a lot thanks

@ELKAMELBI

4 жыл бұрын

You’re welcome Yodev, glad you found it useful

THANK YOU!!!! Exactly what I needed and so useful. Excellent video with clear understanding.

@ELKAMELBI

4 жыл бұрын

Wow! You’re most welcome 🙏 really appreciate it, glad you got here 😊

Great explanation and you made it so simple. Thanks!

@ELKAMELBI

4 жыл бұрын

You’re most welcome 🙏, glad you enjoyed it 😊.

Thanks so much for an easy to understand presentation....from an absolute novice!

@ELKAMELBI

5 жыл бұрын

You're most welcome, and thanks for taking the time to put this comment, it really helps me to keep going, I am glad that the tutorial was easy to understand, I tried my best to make it clear for everyone, glad to see it worked :)

This the easiest and fastest tutorial on dependent drop down without blanks. Thank you for this video! ☺️ Liked, and subscribed. Even added the alarm for new videos.

@ELKAMELBI

2 жыл бұрын

gald you liked it and thanks for the subs. hope I get time to publish new videos soon.

Dear sir, i watch many excel videos for years, today by chance i found your video which is unique navigation list, where i can look into menu of items to choose. it very simple but dynamic for my job. Keep up great work, i shall subscribe to learn more from you.Great Job!

@ELKAMELBI

4 жыл бұрын

You Sir have made my day 😊, thanks for the kind words and I am really glad that you found it useful.

Very helpful, presented in a very simple and understandable manner!

@ELKAMELBI

4 жыл бұрын

Hey thanks :), glad you liked it Omprakash, I do try to simplify things because everything in fact is once you understand it.

i enjoyed your tutorial, *abdallah* … 'specially with regard to the _"indirect"_ function. you explained yourself almost exactly the way i explain myself … when instructing someone.   in the next few weeks … will try implementing _"dependent drop-down lists"_ within *libre-office* or *numbers* _(mac-os)_ … who knows, i might come away with a bit of luck.

@ELKAMELBI

4 жыл бұрын

Thanks so much Pnamajck for the kind words, I am glad you liked the video, Working on a video now to expand on this skill, the new way of dependent drop down list fixed the issue of having spaces in the column header and also a new list can be added automatically, keep an eye on the channel in the coming days, thanks again.

Best explanation and easy steps to follow - thank you so much!

@ELKAMELBI

3 жыл бұрын

Glad you like it Dawn, you're most welcome 🙂

This is a fantastic and simple to follow video!! Thank you very much for this guidance.

@ELKAMELBI

2 жыл бұрын

You're welcome, glad you liked it

been searching everywhere and i found the answer on your video thanks!!!

@ELKAMELBI

6 жыл бұрын

Glad you got here :)

@khalidsaif5582

6 жыл бұрын

Data Secrets Learning I have one question if i would like to add a price to each element in the same table how could I define that ?

Amazing stuff! thank you very much for the video. It was really helpful

@ELKAMELBI

5 жыл бұрын

You're welcome, glad you got here and found it useful, keep on learning :)

This was perfect thank you so much

@ELKAMELBI

5 жыл бұрын

You’re welcome, glad you found the video useful 😊

Thanks. Really, it helps me great tutorial

@ELKAMELBI

6 жыл бұрын

You’re welcome! Glad you found it useful 😊

Still valid in 2019, thank you! If you want to use space or other letter in the main drop down list, you can replace them in the indirect selection: =INDIREKT(BYT.UT(BYT.UT(B10;" ";"");"+";"")) (adapt to your language INDIRECT and SUBSTITUTE) This removes any spaces and + in table header, but still visible in drop down list. Remove the same letters in the name definition.

@ELKAMELBI

4 жыл бұрын

That is correct Jens, SUBSTITUTE can fix the issue of not having spaces in column headers that is used as a list name in naming manager.

I looked at so many videos to learn this. This one explained it so easily and in the shortest amount of time! Great video

@ELKAMELBI

2 жыл бұрын

Glad to hear it! Thanks for the feedback 😊

Great Tutorial, Great Teacher.

@ELKAMELBI

5 жыл бұрын

Thanks Khalid, glad you found the material useful, couldn’t be more happier :)

Thank you so much! This is very helpful!

@ELKAMELBI

3 жыл бұрын

you're most welcome Nazri :)

Fantastic, was a great help :) Cheers

@ELKAMELBI

4 жыл бұрын

Thanks for your comment and feedback

Some pretty slick shortcuts. Explicit. Thanks

@ELKAMELBI

Жыл бұрын

Thanks Type S, feedback like this keeps me going 🙏

Thank you very much for this explanation ...Helped me a lot.

@ELKAMELBI

3 жыл бұрын

Glad you liked it, thanks for the feedback 😊

Very helpful thanks so much.

@ELKAMELBI

5 жыл бұрын

You're welcome, glad you found the video useful :)

Thank you so much. So much to learn from you brother.

@ELKAMELBI

3 жыл бұрын

Glad to hear that, thank you :)

Very neatly described. Thank you

@ELKAMELBI

3 жыл бұрын

Thank you Sumit, appreciate the feedback :)

such an amazing, easy and creative way many thanks for this valuable content guys

@ELKAMELBI

5 жыл бұрын

You're more than welcome إبدأ, comments like yours encourages me to do more, it means a lot!

This video is great, I am so thrilled to learn something I am struggling to address. Thank you.

@ELKAMELBI

Жыл бұрын

I am so glad that you learned something here and hope to find more in the channel, best of luck and thank you for the comment.

thanks you very much sir, it has been helpful

@ELKAMELBI

4 жыл бұрын

You're most welcome :), glad you found it useful

I followed some other youtube videos on this subject but this one is the best. This is an excellent solution. I am impressed. liked and new subscriber to you channel.

@ELKAMELBI

4 жыл бұрын

wow thanks for the great feedback, it means a lot and give me a boost to do more, in fact I have improved this method a bit, keep an eye on the channel there will be a new video soon about this subject. thanks again :)

Excellent video- thank you!

@ELKAMELBI

Жыл бұрын

You're welcome! glad it helped you.

Thank you so much for your great tutorial.

@ELKAMELBI

4 жыл бұрын

You're most welcome Sonjoy! glad you found it useful.

easiest way to create a dependent dropdown list. thanks Man!!!

@ELKAMELBI

4 жыл бұрын

You're welcome and thanks for the feedback Diego. by the way, I have a new video soon that'll make it even better, keep an eye on the channel.

Great! this will help me in my day to day works

@ELKAMELBI

4 жыл бұрын

Thanks Mary, glad you got here 🙏

Awesome and very helpful video! Thank you!

@ELKAMELBI

4 жыл бұрын

You’re most welcome 🙏, glad you found it useful.

@linm8649

4 жыл бұрын

@@ELKAMELBI Could you please help me further? --I entered "fruits" then selected "apples" first, then I changed the "Fruits" to "Vegetables", but "apples" still remains in the cell and i had to manually delete it. Is there a way to let it automatically go away since "Apples" doesn't belong to the new Food Type i selected? If i don't delete it, Data Validation didn't pop out any error message either. Thank you!

@ELKAMELBI

4 жыл бұрын

@@linm8649 for that to work you need to use VBA code to clear the cell after change happens in fruit/vegetable cell but data validation on its own cannot do that. managing lists in Excel is still weak to answer business questions specially when you start having dependent drop-down lists. if you look it up in google you will get a sample code that you can apply, I usually avoid using VBA as much as I can.

how do you add searchable drop down listing to this?

Indeed a very helpful quick video.

@ELKAMELBI

4 жыл бұрын

Glad it was helpful! and welcome to the channel Naveed!

thanks bro, very helpful :)

@ELKAMELBI

5 жыл бұрын

You’re most welcome, glad you got here

Amazing and simple. Thanks a lot

@ELKAMELBI

Жыл бұрын

Thank you 🙏

Thanks a lot. i have tried with many other You tube videos about Dependent Drop down list but could not satisfied . Everything is in this video.

@ELKAMELBI

3 жыл бұрын

You're welcome, thanks for the great feedback

If you have an issue with the indirect function, make sure the reference name (top row) doesn't have any spaces in between characters (ex. "Project Management" switch to >>> "Project_Management" or "PM"). Hope this helps.

@ELKAMELBI

4 жыл бұрын

Thanks for your feedback and you’re right, having no spaces is a best practice and makes things easier when creating lists, however, you can have spaces if you must but you need to also include SUBSTITUTE function to handle spaces.

@horvathgabor5485

4 жыл бұрын

@@ELKAMELBI And what to do when Name has: ( ) ? etc. Not to mention, when these are at the beginning of the Name or at the end?

@ELKAMELBI

4 жыл бұрын

SUBSTITUE Function should handle all those and you use it within data validation, let me know if you need help with that

@horvathgabor5485

4 жыл бұрын

@@ELKAMELBI I don't believe, Substitute can handle ALL of the invalid characters. E.g.: : ; ? @ ¢ £ ¥ { | } ~ « » ! How do you handle these all? Not to mention, that Excel does it differnetly in the name and at the end of the name...

@ELKAMELBI

4 жыл бұрын

I don’t see why not, however, I have used substitute with spaces so far, if you have an example maybe you can send it to me and I will have a look

This is the perfect, the one I was looking for. thanks

@ELKAMELBI

5 жыл бұрын

You’re welcome, glad you found it helpful

Great Interpretation 🙏

@ELKAMELBI

4 жыл бұрын

Thanks Rajdeep, glad you found it useful 😊

Very nice clear & creative lecture thanks

@ELKAMELBI

5 жыл бұрын

You're welcome Abdelhameed! glad you found it useful :)

Very useful. Thank you for sharing

@ELKAMELBI

3 жыл бұрын

Glad it was helpful!

This is what I was looking for a long.. Thanks a lot

@ELKAMELBI

6 жыл бұрын

Glad you got here 😊

Thanks ! I have made my day.

@ELKAMELBI

4 жыл бұрын

Glad you liked it 😊

Hi .Thanks for the video. It really helped me a lot. I have s small doubt. Will this not work if we use a space in between the table headers and drop downs?

@ELKAMELBI

4 жыл бұрын

You can but you will need to use substitute function to make it work, I think I helped someone with that in the comments of this video, if you still have issues you can either describe it here or you can send me an email at abdallah.elkamel(@)gmail(dot)com

Thanks, it helps a lot

thank you very much, jazakallah.

@ELKAMELBI

4 жыл бұрын

You’re most welcome, glad you found it useful.

Neat and Clean technique, awesome

@ELKAMELBI

Жыл бұрын

Thank you :)

awesome topic جزاك الله كل خير

@ELKAMELBI

3 жыл бұрын

مشكور وبارك الله فيك سيد أحمد

Thank you so much for your video

@ELKAMELBI

3 жыл бұрын

Gald you liked it Kevin!

Great video . Thanks

@ELKAMELBI

5 жыл бұрын

You’re most welcome Martin, glad you found it useful and thanks for the subs

Many thanks Mr. Abdallah ! I have been looking for this one. How can I make prices automatically read from (tblPrices)? so we need only to enter the quantity manually.

@ELKAMELBI

4 жыл бұрын

Hi Mohammed, which video tutorial are you referring to? this video doesn't have tblPrices. are you referring to another video? thanks. to answer your question in general, VLOOKUP function is normally used to do this but give me more details, also you can contact me at abdallah.elkamel(at)gmail(dot)com

Perfect! Thanks

@ELKAMELBI

4 жыл бұрын

You’re welcome! Glad you found it useful

Thank you for the tutorial, it has help me understand Data Validations on a whole new level. With that being said, i'm having trouble with something. So I highlight all my headers and give it a name(headers). I confirm that the headers come up in the Name Mgr (Department, Equip, Brand, Model). I have also created tables for each of these headers with information in their respective columns. The problem comes when on a separate sheet, I create the "form" and label it Department, Equip Type, Brand, Model Serial Number. I format all this as a table then I click on the cell under Department. Following your instructions, I go to Data Validation, select List, the in the Source field i enter =headers. When I click on the drop-down box, it shows me the other column headers rather than the departments I had created tables for. Any help is appreciated.

@ELKAMELBI

5 жыл бұрын

You're welcome, glad you've enjoyed it. regarding your question, it is hard for me to visualize what is happening with your file, if you send me your file at abdallah.elkamel@gmail.com I will be able to give you a comprehensive answer, thanks for the sub :)

Thank you and i just learn that we can use indirect function in setting the dropdownlist

@ELKAMELBI

2 жыл бұрын

Brilliant! You're welcome

Really did not know this Gr8

@ELKAMELBI

4 жыл бұрын

Thanks for the feedback, glad you found this useful 😊

Such an important video to watch, it help me alot. Thanks you :)

@ELKAMELBI

4 жыл бұрын

You’re most welcome 🙏, make it Viral, Viral 😁.

@chamnabkem5459

4 жыл бұрын

Data Secrets Learning im just a new comer for ur channel, but guest what! I didn’t disappointed to sub on your channel 😊

@ELKAMELBI

4 жыл бұрын

@@chamnabkem5459 saw that, thanks for the subs :)

Great video and explanation Sumit

@ELKAMELBI

4 жыл бұрын

Thanks 😊, glad you found it useful

Simple and well explained

@ELKAMELBI

4 жыл бұрын

Thank you sir, I appreciate it 🙏

This is so helpful.. please make a program cashiering next time here in excel sir. thank you

@ELKAMELBI

4 жыл бұрын

Thanks Jestony, that is in the works but in the form of invoices connected to products and inventory management

Great tutorial!

@ELKAMELBI

Жыл бұрын

Thanks, glad you liked it

This has helped me a lot. Just trying to work out how to expand this to more dependent. For example maybe there are more than one type of pear or apple etc.

@ELKAMELBI

4 жыл бұрын

Great to hear that Andrew, it can be expanded to three lists but it involves repeating apples, pears ...etc in a horizontal list again with types of apples in a list below the word Apples, it is cumbersome but can be done. Let me know if need help with that.

Data Secrets Learning your the best

@ELKAMELBI

4 жыл бұрын

Art D, thanks so much! You made my day! 😊

Hi thanks for the awesome video. I wanted to know how I can add an item say maybe fruits or veggies later in the list. Thanks once again.

Great Work. Mashallah.

@ELKAMELBI

6 жыл бұрын

Shokran 😊

Thank you so much. You've got a new subcriber. :))

@ELKAMELBI

4 жыл бұрын

You're most welcome Anh :), glad you got here :)

@myanhdo1562

4 жыл бұрын

@@ELKAMELBI I combine it with your guide of smart personal budget. It turns out really cool for me. Thanks again for both tutorials.

@ELKAMELBI

4 жыл бұрын

@@myanhdo1562 I am so glad you found it useful, good luck :)

Thank you so much for the tutorial. It was a tremendous help. I encountered a problem where only some of my 'Foods' pulled through when selecting certain 'Food Types' and others worked perfectly. Where do you suppose the problem occured?

@ELKAMELBI

4 жыл бұрын

You're welcome Adri, glad you found it useful. now normally this happens if the named range is not covering all Foods, to fix that you need to extend the range to cover the missing items. now in the tutorial I reference column name since we are using formatted tables and that take care of it automatically. if you still facing issues you can send me your file at abdallah.elkamel(at)gmail(dot)com and I will do my best to help.

@adriduplooy5929

4 жыл бұрын

@@ELKAMELBI Hi Abdallah, after hours of trying I finally managed to get it to work, thank you so much.

@ELKAMELBI

4 жыл бұрын

I am glad you managed, thanks for letting me know, good luck 👍

WOW GOOD JOB THANKS

@ELKAMELBI

4 жыл бұрын

You’re welcome 😊 Ryanrich, glad you got here

Thanks you so much. 🙏🏿🙏🏿

@ELKAMELBI

4 жыл бұрын

You're most welcome, glad you got here :)

Very good and informative video

@ELKAMELBI

4 жыл бұрын

Thanks for your comment, glad you found it useful

Very helpful thank you

@ELKAMELBI

4 жыл бұрын

You’re welcome Matthew, glad you found it useful. Your comment went to spam for some reason, that’s why it took me some time to reply, thanks.

Its cool. Love it.

@ELKAMELBI

4 жыл бұрын

Thanks 😊, glad you got here. I have improved it, keep an on the channel for a new video on it.

This is perfect, but how would I do this with more than 1 set of subgroups? For example I'm trying to have the first box give me the option to choose area, then the second box give me a list of equipment types in that area, then the third box give me a list of all the equipment that is listed as that equipment type. Further Example: Box A(area) - Cold End Box B(equipment type) - Robots Box C(specific machine) Robot #3 OR Box A(area) - Ware House Box B(Equipment Type) - Conv. Box C(Specific Machine) - Conv. #3 So when I select a certain option in Box A it gives me a certain range of options in Box B that wouldn't be there if I chose a different option in Box A. And when I choose a certain option in Box B(that correlates with Box A) it gives me a selection of options in Box C that would be different if I chose a different option in Box B. If I chose: Box A(area) - Cold End Box B(equipment type) - the options for warehouse aren't there. Only the ones for Cold End are. (Cold End, Warehouse, Robot, Conveyor are just examples.) How would I make this happen? Thank you.

@ELKAMELBI

6 жыл бұрын

Thanks for your question, the way to do it is to create a new set of lists with headers named exactly as those in Box B, under each list header put all those options from Box C that correlates with the header of that list, then follow the same data validation procedure described in the video. If these instructions are not clear, I can create a file for you that you can populate with your data later on, you can even send me a sample of data that I can work on :).

This is the perfect. thanks

@ELKAMELBI

4 жыл бұрын

You’re most welcome 🙏 papaK

Hi, I like your video and am trying to follow it but the name table function doesn’t come up like you demonstrated. And, I cant find name manager under Table Tools. Wondering what version you are using and what I am possibly doing wrong. I’m using office365 on onedrive. Thanks.

@ELKAMELBI

4 жыл бұрын

Thanks Dianne, I believe I was using 2013 version, but there should be no changes between 2013 and 365 which I am also using currently. Name manager should be under formula tab not table tools, and if your table header has spaces you need to throw SUBSTITUTE function in the mix. If you have a business need, I can setup your file for a small fee, I can be reached at abdallah.elkamel(at)gmail(dot)com, can also be reached on skype at abdallah.elkamel

Hi, thanks for this tutorial, really useful... now, Is it possible to do the same drop-down list but instead of showing the value, show some text, for example, using a table of products and prices, and when choosing the product name, the value on the cell changes to the respective price, is it possible?

@ELKAMELBI

4 жыл бұрын

Yes, you use VLOOKUP function to get the price from the product/price table based on the product you select by a drop down list. so the first cell will be a drop down list that lists the products, once you select a product the cell next to it will take the product name you just selected and use VLOOKUP to get the price from the products/price table. I have a video on VLOOKUP on the channel you can check it out.

Thank you , I was wondering is it ok to creat this in a workbook that has 150 sheets and each one will have like 5 dependant dropndown list , couse I don't want to do all of it and ends up having a problem. Another thing is that , is it ok to move or copy sheet that has defined name and still working the same way ? Couse I tried to do that but Excel said we cannot do this in a sheet that has tables. Thank you

@ELKAMELBI

4 жыл бұрын

You’re welcome Mohamed, I don’t know the maximum number of named ranges that Excel can handle, but I would question why you had to have 150 sheets in one workbook, there might be a better option like moving to an Access database or another platform. As for the other question, there shouldn’t be a problem copying or moving a sheet that contains tables or named ranges even if you copy to a new sheet, but you can’t have duplicate names, tables and named ranges need to have unique names. Hope that answers your question.

Thanks for this i have a similar case but on gym thing not to make it complex i will set the question per your context suppose for this case you need to quantity to populate automaticaly according to the chosen fruit type how can i do it i assume each fruit corresponds to a food type,

@mutindafestus5619

6 жыл бұрын

i mean each fruit type corresponds to a quantity how can i have excel populate the quantity i am using v look up but when i reference it to the second list i get an error

@ELKAMELBI

6 жыл бұрын

Thanks for your comment, the best way is to use VLOOKUP function to do that providing that fruit type names are unique, let me know if you need help setting that up.

@mutindafestus5619

6 жыл бұрын

+Data Secrets Learning the problem is that i tried the vlook up a million times but it keeps throwing an error #NA, when i reference it to The depedent list(Fruit list for this case)

@ELKAMELBI

6 жыл бұрын

Hmm, send me your file at abdallah.elkamel@gmail.com and I’ll see what I can do.

@mutindafestus5619

6 жыл бұрын

okay thanks

Great tutorial! I have tried using this with numbers but cant seem to get it to work. I keep getting an error (the source currently evaluates to an error). Is this because the name manager does not allow for #s to be used?

@ELKAMELBI

5 жыл бұрын

Thanks Dean, yes the name manager prevent you from naming any list by a number alone, the name in name manager has to start with either an underscore (_) or a letter, so to get it to work with numbers you need to add underscore to your names in name manager and when using to refer them prefix the cell that contain the number with "_"&. so if cell A1 contains the number that you've used as a name (prefixed by _), you can call the list by writing =SUM(indirect("_"&A1)). does that answer your question, if not send me a sample file at abdallah.elkamel@gmail(dot)com and I'll see what I can do. good luck...

@deanchilakos7298

5 жыл бұрын

@@ELKAMELBI worked like a charm! You sir....deserve a beer! thanks for the help.

@ELKAMELBI

5 жыл бұрын

Hey 👋🏻 glad it worked out for ya, Thanks for letting me know and the beer 🍺, sure i can use a cold one in this hot 🥵 summer.

hi, my excel is showing in the below error when I type =indirect(H2) the last step The Source currently evaluates to an error, do you want to continue? Yes/ NO Please help why this error is showing

@ELKAMELBI

4 жыл бұрын

this error appear when the name of the list is not correct, make sure that the cell H2 contains a list that actually exist. you can send me your file at abdallah.elkamel(at)gmail(dot)com

Your video was really helpful but I have a problem cuz my first record of the first column of the table needs to be validation. How will the table expand automatically in this case?

@ELKAMELBI

6 жыл бұрын

Thanks, yes this is the one case where the table will not expand automatically. you either drag the bottom right corner of the table to add more rows, or use TAB. I prefer using TAB.

@mariostudio7

6 жыл бұрын

Data Secrets Learning Thank you for your answer! :) So if I fill the last cell of the table (for example the Qty entry in the video) and press TAB, it will automatically generate a new record below in the table?

@ELKAMELBI

6 жыл бұрын

Yes that is correct

@mariostudio7

6 жыл бұрын

Thank you very much! :)

very good and advanced lessen

@ELKAMELBI

4 жыл бұрын

Thanks 😊, glad you liked it

Thank you Dependent drop down list video. Would it be possible if you could make video about how to create pivot table in excel in android tablets. And also another video about opening 2 excel files at the same time in android tablets. Thank you

Hi, Trust are are doing well!! What To do If Table name is not showing in the Excel sheet. I am trying to Make a sheet but unble to change the name of table because of its non availablity.

hi. thanks for the video. i have question. how to add price automatically when are selecting the drop down item? i mean when you were selecting food. automatically adding price

@ELKAMELBI

4 жыл бұрын

You're welcome Aldi, glad you liked the video. to make price appear automatically you need to use VLOOKUP function but before that you need to create a list of all your products and their prices, what VLOOKUP does is take the selected item from your drop down list and then go to the price list search for the item in the leftmost column and then pick the corresponding price. if you'd like me to help you send your file to abdallah.elkamel(at)gmail(dot)com.

Clever

hi.. what if i want to make a massive options on the first column? i still need to name the table one by one?? i have about 8.5k of data.

@ELKAMELBI

Жыл бұрын

You’re in luck, a video will drop today hopefully with a ready template that has no limit :)

Do you have an updated version of this since the excel update?

@ELKAMELBI

Жыл бұрын

Yes, I have a fully automated template that you can use over and over again. here a link to the video where you can find a link in the description to download the file kzread.info/dash/bejne/nWykmNWxgsrMmcY.html

Your video was extremely helpful, but somehow I'm stuck. When I try tp create a new row by either pulling down, doing "paste special" or by just typing in the empty row below and having, it still only uses the date from the first row with the main drop down list for example C3. The cells in column D will only show the dropdown for the first cell in column C. If anyone has a solution I would be grateful. Thank you!

@ELKAMELBI

2 жыл бұрын

Make sure the cell is not locked by dollar sign or at least the column should locked not tge row portion of the cell address

This video was very helpful for me to learn the dependent drop down list, but one thing I want to learn is if i hve to bring automatically the price of the food in the next row then what formula i will have to use to get that. I will be glad if you answer to my question..waiting

@ELKAMELBI

2 жыл бұрын

That should be VLOOKUP, you need to have another table that has 2 columns, tbe first is tbe name of food and the second is the price.

awesome...

Wow! I learned a lot. I managed to do it, however what I am wanting to do is once you choose "Food Types" then when you go under "Food" I would like to have a multiple choice drop down menu that includes not active x check boxes. This way when I choose say 2 or 3 vegetables it shows the list of those 3. I don't want to have "vegetables" repeating. My columns would be;"Signed Out By", "Key Type", "Key Name", "Qty". It is a form I'm calling Key Ring Sign-out Sheet. I need to lock the columns because at the bottom of the page I need to put other things such as, signature and date signed. Does this make sense?

@ELKAMELBI

6 жыл бұрын

Thanks for your comment and question. Excel doesn’t support these kind of lists unless you use VBA which I don’t recommend fir this particular request. I recommend you either keep same structure as is with vegetables repeating and use pivot table for your report or move to MS ACCESS where you can store multiple vales in same cell.

@Yassine3333222222

4 жыл бұрын

I'm doing that by 100% VBA code like shown in my video in the link below kzread.info/dash/bejne/p2uNlrFro66uZpc.html and I will explain it by details next few days

Thank you.

@ELKAMELBI

4 жыл бұрын

You’re most welcome, glad you found it useful 🙂

Very interesting!

@ELKAMELBI

Жыл бұрын

Thank you!

Thank you so much Omg God bless you. it was well explained and I was able to follow .Do you have a video on how to add price and weight?

@ELKAMELBI

4 жыл бұрын

Great to hear that, thanks :) , to get price and weight and weight once you choose a product you need to use VLOOKUP, first setup another table that has three columns; first column contains all products but make sure you don't duplicate any product, the second column should contain Price for each product in the first column, and the third column contains weight for each product in first column. this is what I call a master table, now you go back where you have your dependent drop-down lists setup and add two columns one for Price and one for weight so once you select your Food Type and then Food, Price and Weight should appear automatically by using VLOOKUP function that will take the name of the food then go to the master table search for it in the leftmost column and then bring the price, same for weight. to understand VLOOKUP more check this video: kzread.info/dash/bejne/Y3aZsqecec6sc6g.html Also if you have business needs, like setting up this file for business, I can help you for a small fee, you need to send me an email at abdallah.elkamel(at)gmail(dot)com. if you have bigger business needs like designing templates or compete systems, we can talk about it too.