R
Relykk
I have an Excel sheet that I use to keep track of salespeople's dail
statistics, which has manual changes made to it daily. These change
are made to the formula resident within the cell by either incrementin
or decrementing the last number in the formula.
The below code is from merely recording a new macro, selecting the to
data cell in the column, and then clicking within the fx textbox
revealing the formula...
Code
-------------------
Sub UpdateDaily()
'
' UpdateDaily Macro
'
Range("V2").Select
ActiveCell.FormulaR1C1 = "=(165-RC[-20])/48"
End Sub
-------------------
What I want is for the formula: =(165-B2)/48 to be decreased by 1 eac
time the macro is run, so that it will now be...=(165-B2)/47, and the
=(165-B2)/46...each time I run the macro.
If anyone can help me with this, it will be deeply appreciated.
Thank yo
statistics, which has manual changes made to it daily. These change
are made to the formula resident within the cell by either incrementin
or decrementing the last number in the formula.
The below code is from merely recording a new macro, selecting the to
data cell in the column, and then clicking within the fx textbox
revealing the formula...
Code
-------------------
Sub UpdateDaily()
'
' UpdateDaily Macro
'
Range("V2").Select
ActiveCell.FormulaR1C1 = "=(165-RC[-20])/48"
End Sub
-------------------
What I want is for the formula: =(165-B2)/48 to be decreased by 1 eac
time the macro is run, so that it will now be...=(165-B2)/47, and the
=(165-B2)/46...each time I run the macro.
If anyone can help me with this, it will be deeply appreciated.
Thank yo