I'm building a consolidated report on a shared drive which links to several other workbooks. My problem is this: Because there are so many rows which return zero values from the linked cells, the report is far too long. I can't remove the rows, because at some point, the linked cells might have values... so I need to hide them somehow. Is there a way to automatically hide rows which contain (all or some) zero (or prespecified) values?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!