This one seems like a very common need, and I have tried all sorts of macros that do an ok job, but I need an AUTOMATIC solution as well.
It just has to hide all ROWS where column A has a certain value, such as "hide_me". That's it.
(It would be even better if I had a macro version that could run on demand, and an automatic version that runs all the time, using similar VBA construction.)
I don't think an example workbook is needed here.
Bookmarks