Home » Forums » Open Source Learning Center » Question and Answer

formula to insert rows based on a range of Nos. then copy contents down

Submitted by sime77 on 31 January, 2012 - 11:06

Hi

Is there a formula or macro that will look at a range of nos. like in A1 - B1 and insert the relevant number of rows like

I've done here manually then copy the contents of C1-G1 down to row 10?  Then do the same for subsequent ranges

below these, we will have a sheet with hundreds of these ranges on.

thanks

 

 

‹ Find value, copy cell contents and paste to adjacent column (RESOLVED) Multiple files ›
»
Nick's picture

click on the square in the

Submitted by Nick on 31 January, 2012 - 14:46.

click on the square in the bottom right corner of your selection and drag it down. Excel will increment the numbers

»

formula to insert rows based on a range of Nos. then copy conten

Submitted by Anonymous on 31 January, 2012 - 15:19.

Hi

thanks, but that's not what I meant. The data on line 11 was on line 2, I need a formula that
will do that automatically, read the data in A&B and see that 9 more rows need to be inserted below then to copy the data in C-G down to the inserted rows below. Is that possible?

thanks

»