I am try to copy and paste values from each personnel in the Two Week Work Plan to each specific personal summary sheet to log their activities through out the year with the click of a button. I am having trouble with the data keeps on pasting over the existing data and not moving to the next available row in Column A.
Here is what I have so far:
' Record Macro
'Get the last used row into a variable
Dim lastRow As Long
lastRow = ThisWorkbook.Sheets("Sammy").Cells(Rows.Count, "A").End(xlUp).Row + 1
'Copy Summary Data Sheet F3
Sheets("Two Week Work Plan").Range("B11:I24").Copy
'And paste it into the last row (column A) of "Personal Log" sheet
Sheets("Sammy").Range("A" & lastRow).Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
See attached Excel document if you need to play around in it.