troubleshooting Question

Cascading Drop down issues in Excel

Avatar of Audra Breedlove
Audra Breedlove asked on
Microsoft OfficeMicrosoft Excel
5 Comments1 Solution80 ViewsLast Modified:
Hello I've never built a cascading dropdown from scratch.  I have a template that I use every time I need to create one.

Please use the attachment as guidance

Question 1 - On the Tracking Worksheet tab, when select DMI in Area, Column E only gives the selection of Reporting and Reporting when it should be Reporting and Soup.  (selecting TCS in column C does it correctly)

Question 2 - Why when you select an Activity List on the Tracking WorkSheet tab, all the selections on Column I on the Service_Activity List tab are displayed?

Is it all in the order or is there a way to do a cascading dropdown where it works as intended?

Example, On the Tracking Worksheet  tab When you select DMI then Reporting is the only selection and then there's only 3 selections in column I Activity

I have a work around but it requires putting (DMI) at the end of Column B on the Service or Deliverable and (DMI) at the end of every activity that's selected for the Area DMI (same exercise for (TCS), (GR), (SS)

Question 3, this is a nice to have, but it might require coding, If you make all the proper selections, and then go back and change G, is there a validation that tell you Column H and I are incorrect?
Cascading-dropdowns---Expert-Exchan.xlsm
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros