How to Create Dependent Drop-Down List in Excel - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Where
Hi Kevin, thank you for such a brilliant solution - there is only one problem, I would be using this as a Daily Log, with the range of the Transposed filters having to be pre-formulated to 1,100 rows, which would slow down the workbook considerably (as there are 60 columns with formulas in about 20 columns (x 1,100 rows).
Is there a possibility of converting it into a VBA sub? - I'm only reasonably new to VBA and have not idea how to write the code for it.
I'm also trying to set up the Daily Log in a Table format, on a password protected sheet (which I'm now trying to resolve, so that the Table rows will automatically expand when a new entry is made) - I'm trying to minimise user error by messing with my formulas, etc.
So a VBA version of this would be fantastic, and I dare say would help a lot of people with a similar issue.
Again, thank you for your videos, they are beautifully explained and presented - a great learning tool. Please continue your great work, it is certainly appreciated by the multitude !
reply
Hi Kevin, thank you for such a brilliant solution - there is only one problem, I would be using this as a Daily Log, with the range of the Transposed filters having to be pre-formulated to 1,100 rows, which would slow down the workbook considerably (as there are 60 columns with formulas in about 20 columns (x 1,100 rows).
Is there a possibility of converting it into a VBA sub? - I'm only reasonably new to VBA and have not idea how to write the code for it.
I'm also trying to set up the Daily Log in a Table format, on a password protected sheet (which I'm now trying to resolve, so that the Table rows will automatically expand when a new entry is made) - I'm trying to minimise user error by messing with my formulas, etc.
So a VBA version of this would be fantastic, and I dare say would help a lot of people with a similar issue.
Again, thank you for your videos, they are beautifully explained and presented - a great learning tool. Please continue your great work, it is certainly appreciated by the multitude !
reply
Craig
Hey Kevin, great video, I'm getting closer, I want to sort so that previously selected options cannot be repeated. For example, for an activity group, if Person 1 on week 1 has a choice of 10 activities, then week 2 I would want the same list but excluding the previously selected activity. So after 5 weeks, only 5 activities would remain. This way ensuring a different activity each week. I'm guessing it will be a SUMIFNOT type but can't figure out how/where to add this.
reply
Hey Kevin, great video, I'm getting closer, I want to sort so that previously selected options cannot be repeated. For example, for an activity group, if Person 1 on week 1 has a choice of 10 activities, then week 2 I would want the same list but excluding the previously selected activity. So after 5 weeks, only 5 activities would remain. This way ensuring a different activity each week. I'm guessing it will be a SUMIFNOT type but can't figure out how/where to add this.
reply
Steven
Hi Kevin. I have a problem here. Is it possible to edit certain cells only when those cells are selected using data validation? For my case, the cells named -Specific Target Organ Toxicity- need to add names of organs at the same cell. For example, Specific Target Organ Toxicity (Lungs, Nervous System). Thank you if you could solve this
reply
Hi Kevin. I have a problem here. Is it possible to edit certain cells only when those cells are selected using data validation? For my case, the cells named -Specific Target Organ Toxicity- need to add names of organs at the same cell. For example, Specific Target Organ Toxicity (Lungs, Nervous System). Thank you if you could solve this
reply
Sonia
Thank you so much for this video! This was easier than what I've seen in other videos! I love that you provided instructions for adding this to multiple rows. Would you ever consider making a video about it? I followed the entire video and succeeded until I tried adding to multiple rows. THANK YOU!
reply
Thank you so much for this video! This was easier than what I've seen in other videos! I love that you provided instructions for adding this to multiple rows. Would you ever consider making a video about it? I followed the entire video and succeeded until I tried adding to multiple rows. THANK YOU!
reply
Lore
This was very helpful and everything works until I try to do multiple rows. I tried using transpose as part of the formula and it still does not work. It's only gives the picklist of the first row selected not the next row. What am I doing wrong?
reply
This was very helpful and everything works until I try to do multiple rows. I tried using transpose as part of the formula and it still does not work. It's only gives the picklist of the first row selected not the next row. What am I doing wrong?
reply
Sir
Atleast I now know what happened to Adele, she had promised me the recipe----. Great content Kevin, not only sre you concise, you waste no time in getting to the point which makes the videos relatively short. Thank You
reply
Atleast I now know what happened to Adele, she had promised me the recipe----. Great content Kevin, not only sre you concise, you waste no time in getting to the point which makes the videos relatively short. Thank You
reply
Claude
Kevin, I would like to have a dependent dropdown to different worksheets. Forinstance I want to enter either a code to identify a Materials List or a list of labour codes, but those are kept on different worksheets
reply
Kevin, I would like to have a dependent dropdown to different worksheets. Forinstance I want to enter either a code to identify a Materials List or a list of labour codes, but those are kept on different worksheets
reply
Vaci
How would you do this if you want to have multiple lists for multiple sales persons showing at once? Like if you want both Oliver and Kevin to be listed in A8 and A9. How would you have a tailored dropdown for each?
reply
How would you do this if you want to have multiple lists for multiple sales persons showing at once? Like if you want both Oliver and Kevin to be listed in A8 and A9. How would you have a tailored dropdown for each?
reply
Rachel
Thank you very much Kevin. This is really useful however I have to do a dependent drop-down for a huge list. How do you keep the data independent in a list if the filtered list keep changing?
reply
Thank you very much Kevin. This is really useful however I have to do a dependent drop-down for a huge list. How do you keep the data independent in a list if the filtered list keep changing?
reply
Peter
Just started with OBS. I will use it only for training staff with my own written excel program. But OBS is not recording the dropdown menus. Any idea to help me out? Many thanks. Peter.
reply
Just started with OBS. I will use it only for training staff with my own written excel program. But OBS is not recording the dropdown menus. Any idea to help me out? Many thanks. Peter.
reply
Add a review, comment
Other channel videos
