Insert multiple rows

[Michael Norrison]

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.

 

[Michael Norrison]

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.
----
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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