Hello there!
I have recorded a macro via excel that will copy a string of data from one worksheet and paste to another worksheet of the same book.
At the moment it pastes my data to "A13" however this is a table and I would like it to paste to the end of said table, which will not always be "A13". My table is the only thing on the sheet and goes from A:G.
How can I modify my code below to achieve this?
Sub CopyPaste()
Sheets("Magic").Select
Range("J2:P2").Select
Selection.Copy
Sheets("Data").Select
Range("A13").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Coaching Form").Select
End Sub
Thanks in advance.
I have recorded a macro via excel that will copy a string of data from one worksheet and paste to another worksheet of the same book.
At the moment it pastes my data to "A13" however this is a table and I would like it to paste to the end of said table, which will not always be "A13". My table is the only thing on the sheet and goes from A:G.
How can I modify my code below to achieve this?
Sub CopyPaste()
Sheets("Magic").Select
Range("J2:P2").Select
Selection.Copy
Sheets("Data").Select
Range("A13").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Coaching Form").Select
End Sub
Thanks in advance.