Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Everyone
I would like to be able to delete a row if the total is 0. the transactions sheet would look like this(their is 12 transactions sheets) Asset/ Payable acc. 101 Opening B. 0 New B. 30 Accounts 523 10 101 10 524 101 203 523 523 102 -1000 102 -2500 Month Rec. Acc. Amount 101 30 102 -3500 103 0 104 0 105 0 203 0 523 10 524 0 THEN THE REPORTS SHEET would look like this. Year Rec. Acc. Amount 101 30 102 -3500 103 0 104 0 105 0 203 0 523 10 524 0 SO TO RECAP, I would like to delete the rows of accounts that our at 0.00 on the reports sheet. and as well the transactions sheets. THANKS SO MUCH FOR YOUR HELP. -Markitos |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting Details in a Sub total formula | Excel Discussion (Misc queries) | |||
Keep total of cells in a cell after deleting source data | Excel Discussion (Misc queries) | |||
Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions |