Macro to open specific rows

[lunatu]

Macro beginner here hi!

I want to write a marco to open specific rows based on one cells condition. For example (see picture attached) cell B9 condition "new business" defines to open rows 20-35 but all the other rows remains hidden.
Could someone please help me with these?

Br
Macro novice

 

[lunatu]

Macro beginner here hi!

I want to write a marco to open specific rows based on one cells condition. For example (see picture attached) cell B9 condition "new business" defines to open rows 20-35 but all the other rows remains hidden.
Could someone please help me with these?

Br
Macro novice

View attachment 31330

...meaning cell B8 as there is in the picture...