BakerBaker
New Member
- Joined
- Feb 12, 2018
- Messages
- 38
- Office Version
- 2019
- Platform
- Windows
Good morning, thanks in anticipation.
Column A consists of a variable number of rows containing data, with each "block" of rows being separated by a blank row. I would like to be able to insert X number of rows after each existing blank row so that each new "block" of rows totals 13. In the example below "JAN" is row 1 - row 14 - row 27 - row 40 etc
Col. A
Column A consists of a variable number of rows containing data, with each "block" of rows being separated by a blank row. I would like to be able to insert X number of rows after each existing blank row so that each new "block" of rows totals 13. In the example below "JAN" is row 1 - row 14 - row 27 - row 40 etc
Col. A
- 1 JAN
- 2 FEB
- 3 MAR
- 4 APR
- 5 (blank) Insert 8 blank rows
- 14 JAN
- 15 FEB
- 16 MAR
- 17 APR
- 18 MAY
- 19 JUN
- 20 (blank) Insert 6 blank rows
- 27 JAN
- 28 FEB
- 29 MAR
- 30 APR
- 31 MAY
- 32 JUN
- 33 JUL
- 34 AUG
- 35 (blank) Insert 4 blank rows
- 40 JAN
- 41 FEB -etc.