Learn how to apply error checking to dependent dropdown lists when the child (second) list is no longer associated with the parent (first) list. File Download Link: www.bcti.com//...
My favorite characteristic of these videos is use of multiple functions. Thanks!
@bcti-bcti
2 ай бұрын
@@StopWhining491 Thanks; I try to mix it up where possible.
@ilkercalsr8130
3 ай бұрын
Always inspiring. Although i am an upper intermediate excel user, i always find something new from your videos. Thanks a lot.
@bcti-bcti
3 ай бұрын
Thank you!!! So nice of you to say. We appreciate your time.
@IvanCortinas_ES
Ай бұрын
Excellent solution, Bryon. I also use a VBA Change Event, as mentioned. Thank you!!!
@bcti-bcti
Ай бұрын
Thanks for the encouraging words.
@labcdel4384
2 ай бұрын
Bro I'm glad i ran into your videos. Really love your powerQuery videos, learned so much. Earned a new sub!!!!
@bcti-bcti
2 ай бұрын
Thank you so much for subscribing. I don’t ask people to (it sounds like begging), but I do appreciate it when people like the content enough to become a subscriber. It’s good to see the sub numbers go up. Thanks for your support.
@labcdel4384
2 ай бұрын
@@bcti-bcti Be proud of yourself, you deserve the growth. Wish you nothing but the best!
@anindyamukherjee7690
3 ай бұрын
Lovely ❤
@hichamhadj9640
3 ай бұрын
Awesome 🎉
@garyallan69
3 ай бұрын
Wouldn't it be easier to just write a simple worksheet vba procedure to clear the entries in cells A6, A9 and A12 each time A3 was changed? Therefore engineering out any errors or incorrect values.
@bcti-bcti
3 ай бұрын
Yes, provided you are comfortable with VBA and are allowed to use macro-based files in your work environment. If so, then I'm all for it. That's the great thing about Excel; there's always more than one way to solve a problem. Sometimes the video is not about a specific problem, but more about showcasing various features and strategies that can be used in countless other scenarios. A way to inspire users when tackling other kinds of problems. Thanks for watching. Perhaps I'll make a video on your suggested technique. Thanks for the input.
@garyallan69
3 ай бұрын
@@bcti-bcti That’s why I watch these videos. Even if I know the answer, it’s always advantageous to see it from other perspectives. That way you can customise your solution based on your target audience better
Пікірлер: 14