I want to have a drop down list with the name for example calculations, other and with choosing one I can have certain rows hidden on another sheet.
Is there an easy way to do that?

I want to have a drop down list with the name for example calculations, other and with choosing one I can have certain rows hidden on another sheet.
Is there an easy way to do that?

i am trying to hid rows in excel between a row with value “P1” in column B and a row with value “P2” also in column B. i have tried, to my own shame i used Chatgpt for a part but i am stuck now. a part of the code succeeded in hiding the rows, but i was not able to let them reapear when i pushed the button. some of the things i tried are commented out,