Hi,
I have a basic Macro that copies some data from one table and pastes it into another table. It works fine except that it pastes the data into the first row of Tbl_Schedule and overwrites the existing data. I want it to paste the new data into the bottom or last row in the table. My Table where I want the data pasted is called Tbl_Schedule on Sheet1.
Appreciate any help.
I have a basic Macro that copies some data from one table and pastes it into another table. It works fine except that it pastes the data into the first row of Tbl_Schedule and overwrites the existing data. I want it to paste the new data into the bottom or last row in the table. My Table where I want the data pasted is called Tbl_Schedule on Sheet1.
Appreciate any help.
Sub CopyToSchedule()
'
' CopyToSchedule Macro
'
'
Range(Cells(Selection.Row, 1), Cells(Selection.Row, 7)).Select
Selection.Copy
Sheets("Sheet1").Select
Range("Tbl_Schedule[Inquiry Number]").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveSheet.Paste
End Sub