macro

[Stefan]

Hi,

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

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

 

[Stefan]

Correction:

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