PDA

View Full Version : Urgent Help - Macros to Insert Rows in 2 Sheets simultaneously



Mysore
01-20-2012, 01:54 AM
Hi Guys,

Just joined the forum and look forward for some urgent help. 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