| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Blank Rows
How do I insert one or multiple blanks rows after each type of data? The
insert criteria is based on the data in Column D, not column A. Cloumn A B C D E 28FEB07 2006 Q1-Q4 Charge 23.39 31MAR07 2006 Q1-Q4 Charge 23.39 30APR07 2006 Q1-Q4 Charge 30.04 31MAY07 2006 Q1-Q4 Charge 30.04 30JUN07 2006 Q1-Q4 Charge 30.04 31JUL07 2006 Q1-Q4 Charge 30.04 31AUG07 2006 Q1-Q4 Charge 30.04 30SEP07 2006 Q1-Q4 Charge 30.04 29FEB08 2007 Q1-Q4 Charge 8.37 09MAY08 2008 Q1-Q4 Interest 38.69 13JUN08 2008 Q1-Q4 Interest 48.63 11JUL08 2008 Q1-Q4 Interest 49.58 15AUG08 2008 Q1-Q4 Interest 45.61 12SEP08 2008 Q1-Q4 Interest 42.61 10OCT08 2008 Q1-Q4 Interest 46.19 07NOV07 2006 Q1-Q4 Interest 487.01 26AUG08 2007 Q1-Q4 Interest 422.9 16DEC05 2005 Q1-Q4 Principal 300 26SEP06 2006 Q1-Q4 Principal 1751.34 26SEP06 2006 Q1-Q4 Principal 588.15 06NOV07 2007 Q3 Principal 836.74 26AUG08 2008 Q1 Principal 568.13 26AUG08 2008 Q2 Principal 740.34 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to insert blank rows | Excel Worksheet Functions | |||
| How do i insert blank rows between data that is thousands of rows | Excel Discussion (Misc queries) | |||
| insert blank rows | Excel Discussion (Misc queries) | |||
| How can I insert a blank row after every four rows in Excel? | Excel Discussion (Misc queries) | |||
| How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
