Link cells

ali baba

New Member
Joined
Aug 11, 2005
Messages
19
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
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

mdavidge

Board Regular
Joined
Oct 14, 2005
Messages
87
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
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,509
Members
412,671
Latest member
vitaminshop20
Top