Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete row 1 based on condition in cell on row 2 | Excel Worksheet Functions | |||
Macro to delete rows based on a condition | Excel Worksheet Functions | |||
How to delete a data row based on a condition | New Users to Excel | |||
Is there a way to delete a cell value based on a condition? | Excel Discussion (Misc queries) | |||
How do I delete a line in Excel that I only see when printed? | Charts and Charting in Excel |