How to insert different number of rows and drag values from the row before inserted?

[Ekaterina26]

Dear Excel experts,

could you please help me in a macros that would do the following:

1. I have a table 52-cell long and 915-cell wide.
2. Starting from row 2, I need to insert (A3-A2)*17 number of rows after row 2 and drag the same values in all inserted rows from row 2.
3. Go to the next row and insert again (A4-A3)*17 (row numbers will be larger due to inserting row in the previous step) and drag the same values in all inserted rows from row X (X is next row after the last inserted row in step 2.)
and then repeat until the last row.

Thanks a lot for your help!

[Bernie Deitrick]

After you insert rows based on row 2, are A4 and A3 the new A4 and new A3, or the old cells prior to the insertion?

[Ekaterina26]

Dear Bernie,
after inserting rows based on row 2, A4 and A3 moves down to the row that follows after inserted rows, so they are not A4 and A3 anymore. The number of rows to insert is different in each 52 times of inserting and the values to insert in each "row set" is different and should be taken from the row located before row inserting. If any further info is needed, please let me know.

[Bernie Deitrick]

Whenever you are inserting or deleting rows, it is best to work from the bottom up, so try this:

Please Login or Register  to view this content.

[Ekaterina26]

Yes, it works.
How can I adjust the code so that the number of inserted rows is multiplied by 17 (for example, (A3-A2)*17 for the first inserting?
Thanks a lot!!

[Bernie Deitrick]

Sorry - forgot about that part.

Please Login or Register  to view this content.

[Ekaterina26]

Dear Bernie,
thanks a lot, it works.
I tried to do the multiplication in "i=..." part, but get an error. Now I see where you put it properly. Thanks!

[Bernie Deitrick]

You could have done it there, too:

Please Login or Register  to view this content.

[Ekaterina26]

Ah, ok, I did not include ".Value" inside the brackets. Thank you.