I have a table that contains a list of information that I want to use to fill in a number of forms that I have created in different sheet.
The table contains staff name and salary. Rather than going to the form sheet and making a link to the cell in the table sheet, I want to do all the repetitive work with a macro.
Can anybody help because I have around 100 staff.
I tryied this but did not work
Sub Macro2()
Dim i As Integer
For i = 11 To 1546 Step 46
Sheets("Results").Range("C" & i).FormulaR1C1 = "=Summary!R[1]C[1]"
Next i
End Sub
Sheets("Results").Range("C" & i).FormulaR1C1 is ok but "=Summary!R[1]C[1]" is the problem. it gives me wrong data.
Thanks
The table contains staff name and salary. Rather than going to the form sheet and making a link to the cell in the table sheet, I want to do all the repetitive work with a macro.
Can anybody help because I have around 100 staff.
I tryied this but did not work
Sub Macro2()
Dim i As Integer
For i = 11 To 1546 Step 46
Sheets("Results").Range("C" & i).FormulaR1C1 = "=Summary!R[1]C[1]"
Next i
End Sub
Sheets("Results").Range("C" & i).FormulaR1C1 is ok but "=Summary!R[1]C[1]" is the problem. it gives me wrong data.
Thanks