Dear Excel experts,

Query: I need to set up a VBA that whenever I select data from C1 - validation list 'All, Jan, Feb, March & Apr' to show only specific rows as follows:

1) "All" to show cells range A6:G20
2) "Jan" to show cells range A6:G9 and hide A10:G20
3) "Feb" to show cells range A10:G13 and hide A6:G9 & A14:G17
4) "March" to show A14:G17 and hide A6:G13 and A18:G20
5) "Apr" to show A18:G20 and hide A6:G17

Thank you for your help!