Hi all,
I hope this is something that isn't too difficult, and I would also like to thank in advance.
I have a three drop downs (data validation) for a user to select their department in the company; the drop downs reflect a hierarchy (e.g. Level 1 = CEO, Level 2 = General Managers, and Level 3 = Managers)
If the user selects ALL three drop down boxes and hits the "create report" button I've linked to some VBA, they are presented with the table filtered to the three levels they've selected.
The issue is if I am a General Manager (Level 2) and I don't want to select a Level 3 by leaving it blank (essentially the GM wants to see all his Level 3 Mangers data). When the General Manager hits the "create report" button, they are taken to an empty list. I assume this is because there are no "nulls" in the Level 3 column.
I need something in my VBA that says if the relevant drop down is not chosen, blank or null, to ignore it and return ALL values in the Level 3 column.
Any assistance would be greatly appreciated.
Cheers,
Mike
I hope this is something that isn't too difficult, and I would also like to thank in advance.
I have a three drop downs (data validation) for a user to select their department in the company; the drop downs reflect a hierarchy (e.g. Level 1 = CEO, Level 2 = General Managers, and Level 3 = Managers)
If the user selects ALL three drop down boxes and hits the "create report" button I've linked to some VBA, they are presented with the table filtered to the three levels they've selected.
The issue is if I am a General Manager (Level 2) and I don't want to select a Level 3 by leaving it blank (essentially the GM wants to see all his Level 3 Mangers data). When the General Manager hits the "create report" button, they are taken to an empty list. I assume this is because there are no "nulls" in the Level 3 column.
I need something in my VBA that says if the relevant drop down is not chosen, blank or null, to ignore it and return ALL values in the Level 3 column.
Any assistance would be greatly appreciated.
Cheers,
Mike