[RESOLVED] recorded macro - execution time very long

[shailee]

hey wat if i want the same data in h & i coloumn 11th row then, which range should i modify in the code provided by you.

your output


Lookup ID First Name Last Name
111 ccc ddd

wat if we want the same in the next row for ex.

Lookup ID First Name Last Name
111 ccc ddd
333 eee fff

considering the below code how can it work....

'5. Vlookup exp from morning
Range("BM20:BM" & NumRows).FormulaR1C1 = "=VLOOKUP(RC[-61],'MORNING RAW'!R20C4:R[60000]C[-49],13,0)"

Columns("BM:BM") = Columns("BM:BM").Value

' diff

Range("BN20:BN" & NumRows).FormulaR1C1 = "=RC[-49]-RC[-1]"

Columns("BN:BN") = Columns("BN:BN").Value

Columns("BM:BM").Delete Shift:=xlToLeft

Range(" BM19").Value = " EXPOSURE HIKE"