please help me with Vlookup VBA code to fill cells untill last row but look in sheet2 without specified name. It will differ. My table in sheet 1 has about 1 Mil rows.
Dim LR As Long
LR = Range("A" & Rows.count).End(xlUp).row
Range("K2").Formula = "=VLOOKUP(A2,Sheet2!A$2:F$" & LR &...