K
Kevin D
Hi There,
I've searched through a number of topics on this, but could not find
anything similar to my problem.
I have numeric values in column A, and would like to insert the same
quantity of rows beneath -based on the value. The tricky part is that
the number of rows must be one less than the value. So if the value is
6, there should be 5 blank rows inserted beneath. If the value is 9,
there should be 8 blank rows inserted beneath.
A Macro would certainly be the right answer to this, however, I am
unfamilier with writing code.
Here is a before and after sense of what I'm looking for.
What I have......
A B
1 1 CAT
2 6 DOG
3 4 BOAT
4 2 ROCK
5 3 FOX
6 5 SHIRT
7 3 FROG
What I would like to have.....
A B
1 1 CAT
2 6 DOG
3 Blank row
4 Blank row
5 Blank row
6 Blank row
7 Blank row
8 4 BOAT
9 Blank row
10 Blank row
11 Blank row
12 2 ROCK
13 Blank row
14 3 FOX
15 Blank row
16 Blank row
18 5 SHIRT
19 Blank row
20 Blank row
21 Blank row
22 Blank row
23 3 FROG
24 Blank row
25 Blank row
Any assistance would be greatly appriciated.
Thanks in advance,
Kevin D
I've searched through a number of topics on this, but could not find
anything similar to my problem.
I have numeric values in column A, and would like to insert the same
quantity of rows beneath -based on the value. The tricky part is that
the number of rows must be one less than the value. So if the value is
6, there should be 5 blank rows inserted beneath. If the value is 9,
there should be 8 blank rows inserted beneath.
A Macro would certainly be the right answer to this, however, I am
unfamilier with writing code.
Here is a before and after sense of what I'm looking for.
What I have......
A B
1 1 CAT
2 6 DOG
3 4 BOAT
4 2 ROCK
5 3 FOX
6 5 SHIRT
7 3 FROG
What I would like to have.....
A B
1 1 CAT
2 6 DOG
3 Blank row
4 Blank row
5 Blank row
6 Blank row
7 Blank row
8 4 BOAT
9 Blank row
10 Blank row
11 Blank row
12 2 ROCK
13 Blank row
14 3 FOX
15 Blank row
16 Blank row
18 5 SHIRT
19 Blank row
20 Blank row
21 Blank row
22 Blank row
23 3 FROG
24 Blank row
25 Blank row
Any assistance would be greatly appriciated.
Thanks in advance,
Kevin D