Please help! I have a spreadsheet that is linked. When I merge there are some rows that do not meet my criteria and on those rows one cell has NEW# listed and nonthing else. I would like to hide all rows that have NEW# only.
example
D5 NEW# D6 4606 D7 NEW# D8 4607
E5 OLD# E6 5555 E7 BLANK E8 4585
F5 WR# F6 138533 F7 BLANK F8 133831
G5 CC G6 9803 G7 BLANK G8 9803
When I see Row 7 that has blanks accept for column 7 I would like to hide it by a macro or some simple way.
example
D5 NEW# D6 4606 D7 NEW# D8 4607
E5 OLD# E6 5555 E7 BLANK E8 4585
F5 WR# F6 138533 F7 BLANK F8 133831
G5 CC G6 9803 G7 BLANK G8 9803
When I see Row 7 that has blanks accept for column 7 I would like to hide it by a macro or some simple way.