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
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,505
Messages
5,832,128
Members
430,111
Latest member
Francis Xavier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top