Muhammad Shakeel Ishaq
Member
This Vlookup I manage to get work, but is very slow on 10000 or so rows
Sub Macro2()
'
' Macro2 Macro
'
' Keyboard Shortcut: Ctrl+y
'
Range("A3").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC8,'[Consolidated Data Sep-14.xlsx]Sheet1'!C1:C8,R1C,FALSE)"
Range("A3").Select
Selection.Copy
Range("B3:G3").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("A3").Select
End Sub
Googling say Scripting.Dictionary is faster way, but I not used before. Having great trouble finding an example that I can tweak correctly.
Can someone show the way?
Thanks
Sub Macro2()
'
' Macro2 Macro
'
' Keyboard Shortcut: Ctrl+y
'
Range("A3").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC8,'[Consolidated Data Sep-14.xlsx]Sheet1'!C1:C8,R1C,FALSE)"
Range("A3").Select
Selection.Copy
Range("B3:G3").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("A3").Select
End Sub
Googling say Scripting.Dictionary is faster way, but I not used before. Having great trouble finding an example that I can tweak correctly.
Can someone show the way?
Thanks