Barrie....you stated "if you must use VBA".....can you think of another way?
Posted by JC on November 07, 2001 8:53 AM
here is my original post...
"I'm looking for a way to hide rows if certain criteria is met....for example if the value of a certain cell is zero, or blank. Any thoughts? I know this can't be done with conditional formatting, but maybe with some simple VBA...I'm not a VBA expert, so please explain in a bit of detail if you have any ideas...THANKS!!"
Let me add a few details...this is a department spending report (each dept. has it's own tab), so I can't sort the data...it needs to flow by account...I'm looking for a way to hide the rows that represent accounts where that department has not spent any $, or possibly where they have spent very little....(stinks we can't use conditional formatting to reference a single cell in a row)
I can't believe I need to use excel for this (so many inexpensive reporting applications to lay over any ERP), but unfortunately I have no choice....
I would really like to hear a few ideas on this....Mark W. you mentioned "Use AutoFilter (nt)", but there was no explanation....can you expand?
Finally let me say that I found this site recently and think it is GREAT! What an asset to be able to exchange ideas with others using this tool....I hope I can contribute as time goes on.