Dividelink

M

MCheru

In cell A1 Sheet 2, I want to put the result of Sheet 1 F37/F36 and then link
cell G1 Sheet 2 to F36 and I1 Sheet 2 to F37. This is the formula I am using
now.

Sub Dividelink()
Range("A1").Select
ActiveCell.FormulaR1C1 = "='Sheet 1'!R[36]C[5]/' Sheet 1'!R[35]C[5]"
Range("G1").Select
ActiveCell.FormulaR1C1 = "='Sheet 1'!R[35]C[-1]"
Range("I1").Select
ActiveCell.FormulaR1C1 = "=' Sheet 1'!R[36]C[-3]"
Range("I1").Select
End Sub

Is there an easier way to do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top