To hide/unhide rows based on specific value in a cell.

[@jerry]

Hi All,

I want to create a macro which will basically refer say Cell E5 for value say A and keep 4,5 & 6 rows unhidden & hide rows 7,8,9 and rows 12,13,14. Incase the value is B then it should hide 4,5,6 & 12,13,14 hidden and keep 7,8,9 unhidden. Incase of value C then it should hide 7,8,9 and 4,5,6 hidden and 12,13,14 unhidden.

I have attached a sample sheet for reference.

any help would be highly appreciated,

Thanks
@Jerry