Hi.
I'm not sure if this is possible, but I need to write code to hide an entire row if the cells in columns B-F ALL equal either N/A, TBD, or Unknown. Or, to put it another way, if any cell in column B-F has a date, I do NOT want it to be hidden.
For example: I would want rows 1 and 4 below to be hidden automatically (but this is just an example from a much larger worksheet).
A B C D E F G H I J K
11003 N/A N/A TBD TBD TBD Oil Sands Shell Labor Supply Unknown $100,000.00
11006 N/A N/A 28-Oct-11 N/A 28-Oct-11 Wear Imperial Oil Kearl Lump Sum $6,000.00
11007 N/A N/A N/A N/A 20-Feb-12 Wear Suncor Various Projects Lump Sum $35,000.00
11009 N/A N/A TBD TBD Unknown South Shell Maintenance Unknown $60,000.00
Is there a code that can do this?
Bookmarks