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
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