I currently have a data validation list drop down that once the value changes it actions a Macro.
The issue is that I have 56 variables and I feel like writing 56 separate macros seems too much I must be missing something.
The VBA I am currently using is as below.. I am repeating this 56...