Insert multiple rows

[Guest]

Hi, is there a way to insert multiple rows (that conatin certain column
values) for each existing row in a worksheet? Thanks.

 

[David McRitchie]

Hi Michael,
See insert rows maintainining formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
it is set up to retain formulas and clear constants, but you
can modify which columns get cleared so you can maintain
some of the constants.
-

 

[Guest]

Thanks David. That's a very helpful page.

MN

Hi Michael,
See insert rows maintainining formulas
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
it is set up to retain formulas and clear constants, but you
can modify which columns get cleared so you can maintain
some of the constants.
-