Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to insert the empty rows where you say, but then sum the columns
D,E,F,G. So, $300 would appear in the newly inserted row in cells D3,E3,F3,G3. Then Loop and do the same all the way down. "merjet" wrote: Let's see if I get it. Suppose data in rows 1-3 looks like this: 8999 Path & Lab/ 1234XN425 / 2224 Text Name / $100 / $100 / $100 / $100 8999 Path & Lab/ 1234XN425 / 2224 Text Name / $200 / $200 / $200 / $200 8901 Mental Health/ 1234XN425 / 2224 Text Name/ $1234.00.... You want to insert empty rows at 3 & 4, pushing the 3rd line of data to row 5. Where do you want $400 and $800 ? Cells A3 and B3? Merjet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text to Rows and then Insert Blank Rows | Excel Discussion (Misc queries) | |||
How do i insert blank rows between data that is thousands of rows | Excel Discussion (Misc queries) | |||
How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
Insert a blank Column Every 9 Columns | Excel Programming | |||
Insert Blank Column every 9 Columns | Excel Programming |