inserting a number of rows by input in a cell

[Samputa]

Is the following possible, if yes, how:
I want to fill in a number in a cell, which corresponds to the number of
rows that will be inserted on the next sheet on a specific location (between
row 8 and 9). The rows that are inserted must be filled with the same
formula's as the row(s) above (row 8). the number of rows must be dynamic.

Normally I would do this by hand:
- insert X rows
- select the two rows above those rows
- pull down the rows to create the same formula's

 

[Dave Peterson]

David McRitchie has a macro that almost does what you want.

Instead of using a cell to get the number of rows, it just asks you.

http://www.mvps.org/dmcritchie/excel/insrtrow.htm
look for: InsertRowsAndFillFormulas