how to delete an excel line based on a condition

  • Thread starter Thread starter The cricket
  • Start date Start date
T

The cricket

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?)
 
Excel functions generally return a value rather than perform an action,
deleting cell values would be deemed as performing an action.

Have you tried using conditional formatting in the cells with values you
want to 'disappear', set the font colour to be the same as the background
colour when the cell value equals zero.
 
Hi

you could apply an Autofilter to the data.
Select a dropdown on any of the columns with 0 and use Custom>does not
Equal>0
Then print the visible data.

Alternatively, used Advanced Filter to bring across to your Printout Sheet,
only those lines that do not have zero values.
More help on advanced filter can be found at Debra Dalgleish's site
http://www.contextures.com/xladvfilter01.html
 
Back
Top