Guys, How do i change the below to paste as value to the last row of the Sheets("BA Audi SMOT NC Values")
Sheets("BA Polk Audi Serv & MOT N Calls").Select Cells.Select
Selection.Copy
Sheets("BA Audi SMOT NC Values").Select
Selection.PasteSpecial Paste:=xlPasteValues...