I've used macros before to hide rows based on the value on a cell. However, for the life of me I cannot figure out how to duplicate the macro for other cells/rows. For example:
If C4="Y" or "N" or cell is BLANK, then hide rows 5-6. If C4="U" then show rows 5-6.
I also need
If C20="Y" or "N" or cell is BLANK, then hide rows 21-22. If C4="U" then show rows 21-22.
And I will add more conditions for cells and rows.