Link cells

[ali baba]

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

 

[mdavidge]

I dont know how to write a macro for this but there may be a simple way to do this with formulas.

Do you have an example of the the table and forms?

Mike