Hello NBVC can you pls help me in below metter
Hi
I have to do daily no's of vlookup and its taking lots of time now i got one code is below but its only doing one vlookup at one time and every time i have to change the range as per requirements so any body have any idea how can i do multiple vlookup in one time and fast way
Sub Macro5()
Range("K1").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC10,Armine!C1:C3,2,0)"
Range("J1").Select
Selection.End(xlDown).Select
Range("K25365").Select
Range(Selection, Selection.End(xlUp)).Select
Selection.FillDown
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Selection.End(xlUp).Select
End Sub
thanks in Advance
Arvind