Philip1957
Board Regular
- Joined
- Sep 30, 2014
- Messages
- 182
- Office Version
- 365
- Platform
- Windows
Greetings,
I am attempting to copy a row from a table on 1 worksheet and paste it into another table on a different worksheet in the same workbook.
The copy & paste works, but the pasted row is not included as part of the table on the second worksheet. What am I doing wrong?
Thanks in advance for any assistance.
~ Phil
I am attempting to copy a row from a table on 1 worksheet and paste it into another table on a different worksheet in the same workbook.
The copy & paste works, but the pasted row is not included as part of the table on the second worksheet. What am I doing wrong?
VBA Code:
Sub CopyNumDate()
' Copy ECO# & Due Date from Approvals to Days late
Dim lRow As Long
With Sheets("Approvals")
lRow = .Range("A" & Rows.Count).End(xlUp).Row
.Rows(lRow).Copy Destination:=Sheets("Days Late").Range("A" & Rows.Count).End(xlUp).Offset(1)
End With
End Sub 'CopyNumDate
Thanks in advance for any assistance.
~ Phil