This was spot on what I was looking for. Add the same rule, but change the cell values for how ever many dependent lists you have and you are golden! Thank you so much for making this!
Thnak you so much for the very helpful Information.I have a question , if i want to do the same Thing again in the same sheet but this time for the different columns so how to write a code within vba worksheet.Waiting for your ResponsThanks in advance
After the excel drop downs are created, is there any way to remove all the information so that just the drop downs show? Or you need to keep all that information (as an example, the information on the right side of your excel sheet) in order for the drop downs to still work? Currently, we are working on an excel document, but this example wouldnt work as we cannot have all that information shown on our document twice (once written out to create the lists, then the lists themselves).
This was spot on what I was looking for. Add the same rule, but change the cell values for how ever many dependent lists you have and you are golden! Thank you so much for making this!
Thank you! this was exactly what I needed!
Thank you so much. Exactly what I needed!
Thank you very much. Thats exactly what i was looking for days.....
Thank you. Worked for me.
Thnak you so much for the very helpful Information.I have a question , if i want to do the same Thing again in the same sheet but this time for the different columns so how to write a code within vba worksheet.Waiting for your ResponsThanks in advance
how to implement same logic to entire column
After the excel drop downs are created, is there any way to remove all the information so that just the drop downs show? Or you need to keep all that information (as an example, the information on the right side of your excel sheet) in order for the drop downs to still work?
Currently, we are working on an excel document, but this example wouldnt work as we cannot have all that information shown on our document twice (once written out to create the lists, then the lists themselves).
This code only the single cell reset.how to apply the code for entire column? can you help me
the point where it is-
range ("c9").value=""
change to-
range ("c9:C40").value=""
@@jimbradshaw6882 Not Working. when I changed the first cell value , then automatically changed the other cells values.
Thanks a lot ... very helpful information
Sir, you are my hero. thanks!
Perfect explanation.
Awesome!
Thanks!!!
Control + Shift + '+' to Zoom-In use '-' to Zoom-Out.
This doesn't work for me.
too long, should be more direct , yet gave me the info was looking for