I generate proposals in Excel. I have a calculation worksheet and a proposal
worksheet. Based on certain product selections, I want to delete the rows of
the products with zero quantities on the proposal worksheet. At the moment it
needs to be done manually, which is tedious. Is there a way to make the rows
with zero quantities "disappear" or be deleted automatically - or on demand?
Any suggestions? (Or will this this require higher level programming?)