So, Im relatively new in this macro stuff.
Ive recorded a macro, but how do I make it generic? Right now I have to constantly change and add inputs for it to continue my calculation. I just need it to jump to a cell, deduct a number and then head to another cell.
This is my inital recording
Sub Macro1()
'
' Macro1 Macro
'
'
Range("G363").Select
ActiveCell.FormulaR1C1 = "=R[10]C[-6]-R[9]C[-6]"
Range("G364").Select
ActiveCell.FormulaR1C1 = "=R[11]C[-6]-R[10]C[-6]"
Range("G365").Select
ActiveCell.FormulaR1C1 = "=R[12]C[-6]-R[11]C[-6]"
Range("G366").Select
ActiveCell.FormulaR1C1 = "=R[13]C[-6]-R[12]C[-6]"
Range("G367").Select
ActiveCell.FormulaR1C1 = "=R[14]C[-6]-R[13]C[-6]"
Range("G368").Select
ActiveCell.FormulaR1C1 = "=R[15]C[-6]-R[14]C[-6]"
Range("G369").Select
ActiveCell.FormulaR1C1 = "=R[16]C[-6]-R[15]C[-6]"
Range("G370").Select
ActiveCell.FormulaR1C1 = "=R[17]C[-6]-R[16]C[-6]"
Range("G371").Select
ActiveCell.FormulaR1C1 = "=R[18]C[-6]-R[17]C[-6]"
Range("G372").Select
ActiveCell.FormulaR1C1 = "=R[19]C[-6]-R[18]C[-6]"
Range("G373").Select
ActiveCell.FormulaR1C1 = "=R[20]C[-6]-R[19]C[-6]"
Range("G374").Select
ActiveCell.FormulaR1C1 = "=R[21]C[-6]-R[20]C[-6]"
End Sub
Thanks in advance
Bookmarks