littlejilly
Board Regular
- Joined
- Sep 8, 2011
- Messages
- 168
good afternoon friends and happy memorial day for those of us stateside!
I am working to update a pricing calculator and would like to show/hide rows based on a number of 1 or more drop downs. For example, if cell D3 in the capture below is DiseaseExperience, then Row 9 (DiseaseExperience) should hide. Additionally, cells D:H of that same row should also clear from any prior selections.
There are a number of other intersecting conditions that might happen but I'm hoping is someone can start me on the code, I can adjust thereafter for the nested conditions. I'd very much like for the code to update on click.
Thanks!
I am working to update a pricing calculator and would like to show/hide rows based on a number of 1 or more drop downs. For example, if cell D3 in the capture below is DiseaseExperience, then Row 9 (DiseaseExperience) should hide. Additionally, cells D:H of that same row should also clear from any prior selections.
There are a number of other intersecting conditions that might happen but I'm hoping is someone can start me on the code, I can adjust thereafter for the nested conditions. I'd very much like for the code to update on click.
Thanks!