I need to Hide/Unhide a set of rows in excel based on what cell value is selected.
I have a set of data of approximately 3000 rows. I want all these rows (2:3000) hidden
When I write A in Cell A1 the excel should unhide rows from 2:100
Similarly when I select B in Cell A1 excel should unhide rows from 101:200
and so on.