Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotals - add formula to blank cells
Hi:
You all probably know that when you use the subtotal function it adds a blank line with totals below the columns that you specify. Is there a way to get the blank lines to fill using the row above the blank cell? I can add a formula manually but I have over 50 spreadsheets so I hoped that there was a code that would add the contents of the row above if the cell is blank. Example: Columns - Customer Name SalesRep Total Sales$ no data appears in the Customer Name and Sales Rep - only Total Sales$ since that column holds the subtotals. I need a code that will say if the cell is blank after subtotal then add the contents of the row (cell) above. This will show me the data in each row once I expand the (+) to the left. Please help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) | Excel Discussion (Misc queries) | |||
calculating subtotals for sequential blank cells in 1 column | Excel Worksheet Functions | |||
Why do i have blank lines in my subtotals results | Excel Worksheet Functions | |||
Subtotals including blank rows | Excel Discussion (Misc queries) | |||
Excel subtotals cells with a formula - HELP | Excel Worksheet Functions |