Solved: macro to copy data - down other columns
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]
assist with part completed macro
hi
Need to finish this macro so that it populates the results in columns M:N based on column A data last cell
VBA:
Sub Vlookup_KE_24() Application.ScreenUpdating = False ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-12],'KE24'!C1:C13,7,0)" ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-13],'KE24'!C1:C13,13,0)" Application.ScreenUpdating = True End Sub