how to delete an excel line based on a condition
 

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?)

how to delete an excel line based on a condition
 

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.
--
Regards - Peter


""The cricket"" wrote:

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?)

how to delete an excel line based on a condition
 

Hi

you could apply an Autofilter to the data.
Select a dropdown on any of the columns with 0 and use Customdoes not
Equal0
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
--
Regards
Roger Govier

""The cricket"" <"The wrote in message
...
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?)