Insert numbers of based upon difference of two numbers

[excellentlearner]

hi- thank you to anyone who replies in advance.. but I have a file with a min in column P and a max in column R. Is it possible to write a code that would calc the difference between the two numbers and copy&insert those amount of rows.

ex:

row1 info1 info2 info3 7 10 info4
row2 info5 info6 info7 10 12 info5

goal:

row1 info1 info2 info3 7 14 info4
row2 info1 info2 info3 7 14 info4
row3 info1 info2 info3 7 14 info4
row4 info5 info6 info7 10 12 info5
row5 info5 info6 info7 10 12 info5

[Wieli]

Im not sure if i follow you

lets say if you have the number 7 in column "p" and 10 in column "R" you want it to insert 3 rows and copy the data from the row you were working with?

If so will you do this with every row or just one by one?

[tom1977]

look at attachment and try to adjust this code to your conditions

[excellentlearner]

hi wieli, yes- that is correct. so, from my very confusing example above, i would essentially want the first row copied (and inserted) three times ( 10-7) and then the second row down (10-12) would be copied and inserted 2 times... so after the macro is ran "row2"...would become the fourth row down.

i am sorry.. i see my goal got messed up. it should have stayed at
row1 info1 info2 info3 7 10 info4
row2 info1 info2 info3 7 10 info4
row3 info1 info2 info3 7 10 info4

[tom1977]

Ok change my code for this one and try to adjust

Please Login or Register  to view this content.

[excellentlearner]

sample file ex.xlsxthak you, i am attaching the sample file. basically, i have labeled the sections- original- after macro to copy and insert rows based on DIFF colum- the goal result. So I want to the Ages columns to be sequential from the min to the max ages for each CODE.

thank you sooooo much!!!

[tom1977]

This is not speed's deamon but works (I hope)

Please Login or Register  to view this content.

[excellentlearner]

awesome! works perfectly!!! thank you Tom!