Hi All,
I need a macro that will hide a rows based on selected Case in cell "A1".
To be more precise what do I mean. Case in cell A1 means: 1 (is January), 2 (February) and so on.
When I put the data e.g. January (range D3:H3) and (D22:F22) and when I select case 1 in cell A1, I want from Macro to hide ALL rows where I don't have the Data for other Months, but Quater range need to be skipped as I don't want to hide it.
And I will have similar tables also in Sheet2, Sheet3 etc.
So, is it possible to write a code for this?
Thank you in advance.
Bookmarks