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

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

 

 

Nick's picture

click on the square in the

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

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