Hi

Need to change the current macro so that is populates the formula down columns B:F based (staring at row 6) on column A6 until the las cell with data....

[VBA]
Sub Macro4()
Workbooks.Open Filename:="D:\Users\LKassai\Desktop\VOCH\SA38.xlsm"
Windows("Margin File.xlsm").Activate
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],SA38.xlsm!C1:C8,2,0)"
Range("C6").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],SA38.xlsm!C1:C8,5,0)"
Range("D6").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],SA38.xlsm!C1:C8,6,0)"
Range("E6").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-4],SA38.xlsm!C1:C8,7,0)"
Range("F6").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-5],SA38.xlsm!C1:C8,8,0)"
Range("F7").Select

End Sub
[/VBA]