Billman101
New Member
- Joined
- Feb 14, 2019
- Messages
- 9
Hello,
First time post/reply. I'm a pro at recording macros :wink: but not so much on writing them. I'm trying to insert Row(s) based on cell value(s) that reside within my sheet.
Cell A3 has a value of N = 3 and I'd like to insert N rows at row 5 (two rows lower than 3). Then
at Cell A6 which has a value of N = 26 I'd like to insert N rows at row 8 (again two rows lower) and so on as depicted below:
<tbody>
</tbody>
Thanks for any insight you have,
Bill
First time post/reply. I'm a pro at recording macros :wink: but not so much on writing them. I'm trying to insert Row(s) based on cell value(s) that reside within my sheet.
Cell A3 has a value of N = 3 and I'd like to insert N rows at row 5 (two rows lower than 3). Then
at Cell A6 which has a value of N = 26 I'd like to insert N rows at row 8 (again two rows lower) and so on as depicted below:
3 | Sunday | 2/17/2019 |
26 | Monday | 2/18/2019 |
16 | Tuesday | 2/19/2019 |
17 | Wednesday | 2/20/2019 |
19 | Thursday | 2/21/2019 |
16 | Friday | 2/22/2019 |
2 | Saturday | 2/23/2019 |
<tbody>
</tbody>
Thanks for any insight you have,
Bill