keilah
09-06-2007, 01:26 AM
Hi
I need assistance with a macro that well copy and paste "exact copy of formulas".........condition that the cursor has to be placed in the row that will be copied
Here is the question: say i have date in row 69 and column G (staring point)
I need a macro that will do the following steps:
1. Insert two rows below row 69 column G (this is were the cursor willbe placed) or a msg box indicate were to add the two rows from......
2. the first row that is added to format row height "fixd" to 9
3. second row stay the normal height
4. in the second row copy and paste all the forumla from row 69 into it.
5. the ability to repeat the steps - once the next end of month comes up...
6. copy all formulas from row 9 column G to last column....
I need assistance with a macro that well copy and paste "exact copy of formulas".........condition that the cursor has to be placed in the row that will be copied
Here is the question: say i have date in row 69 and column G (staring point)
I need a macro that will do the following steps:
1. Insert two rows below row 69 column G (this is were the cursor willbe placed) or a msg box indicate were to add the two rows from......
2. the first row that is added to format row height "fixd" to 9
3. second row stay the normal height
4. in the second row copy and paste all the forumla from row 69 into it.
5. the ability to repeat the steps - once the next end of month comes up...
6. copy all formulas from row 9 column G to last column....