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