Unhide rows based on cell Value

Copper Contributor

I need help writing a macro because I cant get what I have found online to work. 

 

I have a excel sheet called Check List.

In box K6 I have a drop down with options from 0-10 and a blank. 

 

What I need is if its blank to hide rows 8-38. 0 also hide 8-38, 1 hide 12-38, 2 hide 15-38, 3 hide 18-38, 4 21-38, 5 hide 24-38, 6 hide 27-38, 7 hide 30-38, 8 hide 33-38, 9 hide 36-38, and ten unhide all rows 8-38

0 Replies