Sub Call_times()
'
' Call_times Macro
' Copy and paste VLOOKUP to pull call times into GP Report
'
'
Range("U4").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-18],'[Call times - Yesterday.xls]Recovered_Sheet1'!R1C1:R400C11,11,0)"
Range("V4").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-19],'[Call times - Five days.xls]Recovered_Sheet1'!R1C1:R400C11,11,0)"
Range("W4").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-20],'[Call times - Month.xls]Recovered_Sheet1'!R1C1:R400C11,11,0)"
Range("U4:W4").Select
Selection.AutoFill Destination:=Range("U4:W22"), Type:=xlFillDefault
Range("U4:W22").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("U4").Select
End Sub
Bookmarks