Hi, i would like a macro or excel formula to hide row and columns based on the content value of the first cell of each row or column. I must be activated by an excel cell located elsewhere. I need it to work in an excel file that has many sheets. I want to be able to hide and unhide all rows and columns in the excel file for the different sheets based on a single cell value
hide_unhide.JPG
Bookmarks