On a daily basis I have to copy formulas over to new cells. For example the formula is currently in cells R58 and R59. Today I want to copy the formula to S58 and S59. Tomorrow I will need to copy the formula to T58 and T59. The copying goes on throughout the month. So the macro will need to move to the next blank cell or go by date. The macro I created keeps repeating the same action over and over in the same cells.
Here is the code to the current macro
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 10/25/2002 by cniva
'
' Keyboard Shortcut: Ctrl+d
'
Range("R50:R51").Select
Selection.AutoFill Destination:=Range("R50:S51"), Type:=xlFillDefault
Range("R50:S51").Select
Range("R58:R59").Select
Selection.AutoFill Destination:=Range("R58:S59"), Type:=xlFillDefault
Range("R58:S59").Select
End Sub
Here is the code to the current macro
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 10/25/2002 by cniva
'
' Keyboard Shortcut: Ctrl+d
'
Range("R50:R51").Select
Selection.AutoFill Destination:=Range("R50:S51"), Type:=xlFillDefault
Range("R50:S51").Select
Range("R58:R59").Select
Selection.AutoFill Destination:=Range("R58:S59"), Type:=xlFillDefault
Range("R58:S59").Select
End Sub