Insert Rows

--------------------------------------------------------------------------------

Hi Guys,

I have basically 2 sheets of same structure. The First sheet holds data and flow into the second sheet to perform some calculations. I need a macro to do the following,

--> In Sheet A, when the rows gets exhausted (I have a row for totals Say Row 715) before this total Row, I need a new row to be populated automatically (I mean macros based on event) and copy the formula from above.
To illustrate, when row 714 is filled up, a new row should populate between row 714 and row 715(Total Row) and copy the formula only from Row 714.

--> The above should happen in Sheet B at the same specified rows .

Any help is much appreciated.

Thanks

Hi Dave,

Please see a sample workbook as attached.
Hope this helps.

Thanks

Thanks Dave.

Just wondering now whether it would be possible to insert 100 rows instead of 1 row.
If so can you give the code or update straight on the workbook.

Thanks once again for your help.

Hi Dave

Sorry to note that now I realise that my two sheets are not indentical. No of Columns with formula in sheet2 varies with sheet1.
However there is a text called "Total" under Column A in both the sheets. I want to insert 100 rows before this row which has "Total" under column A.
The macro should also copy formula from above. Note no of columns in Sheet 2 are different in Sheet 1.
Can you resend the code please?

Many Thanks

Hi Dave,

I have atttached the sheet and also put a note in sheet 1.
Hope this is clear.
Thanks

Appreciate your help.

Hi Dave,

Any luck yet?
Thanks