Hi,

I´m looking to create a macro that will do the following procedu

If column b2:b45 contains the value "Role 1" and "all" show rows containing
values.

I will use a dropdown list with macros with role 1, role 2...

Regards
Stefan