Macros

[Closed]
Report
Posts
1
Registration date
Tuesday July 26, 2016
Status
Member
Last seen
July 26, 2016
-
I need to take info from sheet1 line a and copy & paste special on sheet 2 and every time i run macro to copy same way and paste on next empty line. This is what i have so far and i am stumped

Sub Summarize()
ThisWorkbook.Sheets("Main").Activate
Range("A2:N2").Select
Selection.Copy
Sheets("Total").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range("A2").Select
End Sub