I am extremely new to macros (as in an hour old). I have a workbook with over 250 sheets and I need a macro to take the formula below it and bring it up.
Example:
Every worksheet represents a fund & every fund has a specific place on the first page of my workbook.
Every month new money is put into the funds which changes the funds' average balance for that year
At the bottom of each worksheet there is a fund average balance for 2011, 2012 & 2013
Balances for 2011 & 2012 have already been established so I want the formula to draw the specific fund number & show me the balance for that year & for the specific fund.
Here is the macro formula I recorded for ONE of the tabs...
Sub Macro1()
'
' Macro1 Macro
'
Range("F49").Select
ActiveCell.FormulaR1C1 = "='2012 for 2013 Payouts'!R5C[14]"
Range("F48").Select
ActiveCell.FormulaR1C1 = "='2012 for 2013 Payouts'!R5C[14]"
Range("F47").Select
ActiveCell.FormulaR1C1 = "='2012 for 2013 Payouts'!R5C[14]"
Range("F47").Select
ActiveCell.FormulaR1C1 = "='2012 for 2013 Payouts'!R5C[12]"
Range("F48").Select
ActiveCell.FormulaR1C1 = "='2012 for 2013 Payouts'!R5C[13]"
Range("F49").Select
End Sub
My problem is that it is pulling from the same place (i.e "fund") in the first page of my workbook. How can I have it pull from the next line on the first page of the workbook, or is that not possible.
Hopefully this makes a little sense.
I would appreciate any help you can offer me!
Bookmarks