VBA Challenge with conditions

[MrMel76]

OK here the thing.

I have created a sheet for my work that shows financial data.
But this data I only want visible based on several conditions( possibilities)
To make matters more complicated more than one condition can occur.
Also These conditions are triggered by cell value based on a dropdown selection In one case A this cell value is on a different sheet

I have marked the areas A /B/C/D with also signify the condition options.
A= (number of people) I want to make part of my selection with a max of 5 ( which will be triggered from a different sheet
B= if contractual salary growth conditions are taken into account
C=Perfromance bonus taken into account
D= Performance Bonus not taken into account so only salary growth is taken into account.

Never mind the logic of these conditions as this a mock example


The possibilities are: from starting point A/B/C/D so eveything visible

• A
• A/B
• A/B/C
• A/B/D
• B
• B/C
• B/D
• C
• C/D
• D

Now i have solved this with grouping and conditional formating, but I thought maybe I could make it a bit fancier with VBA as this is going to be used company wide.
Can this be done with VBA?

I wll upload a screenshot.

 

[MrMel76]

[url]https://app.box.com/s/b6gsf2c3h5crqg4q1ued5igoiveha4wv


[/URL]