If GENERAL! G1 = VALIDATIONS! G2, then GENERAL! E38 should have a dropdown list with the data from VALIDATIONS! B2:B4 (with data input check)
If GENERAL! G1 = VALIDATIONS! G3, then GENERAL! E38 should not have any data validations conditions nor any dropdown.
Last edited by jeriss; 06-19-2022 at 01:21 PM.
Replace the current Worksheet_Change macro with this one:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Absolutely wonderful, it works perfectly thanks!
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks