Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A B C D E
Product Sub Sub Sub Sub Code Code Code Code Code -1 -2 -3 -4 111 0 0 0 25 222 0 0 0 0 333 5 1 0 0 444 0 0 0 0 555 1 0 0 0 666 0 0 1 0 In the above example I have: 25 of Product Code 111-4 0 of any Product Code 222 5 of Product Code 333-1 and 1 of Product Code 333-2 0 of any Product code 444 1 of Product Code 555-1 and 1 of Product Code 666-3. Each box contains a formula that refers to other sheets. It is not blank, but the result of the formula is zero. I would like to delete the rows with the 222's and the 444's because the sum of columns B thru E is zero. Is there a way to do this via a Macro. Thanks, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Cross"-Auto filling: consecutive columns into rows | Excel Worksheet Functions | |||
"Print titles must be contiguos and complete rows or columns?" | Excel Discussion (Misc queries) | |||
Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
Possible to "rotate" range of cells so columns are rows and vice versa? | New Users to Excel | |||
Deleting "duplicate" rows | Excel Discussion (Misc queries) |