Append data from one table to another

[MAdams]

Hi there,

I'm new to using Macros within excel and I'm trying to write one that grabs data from 11 columns with a varying number of rows and appends it to the new free row in another table.

I know this should be relatively easy, but as I said I'm new to this.

Any help would be greatly appreciated

 

[Max1616]

Hello, without a more complete idea of how your data looks, this is the best I could do:

Sub MoveData()

Dim ws1 As Worksheet
Dim ws2 As Worksheet
Dim lrow1 As Long
Dim lrow2 As Long

Set ws1 = Sheets("Sheet1") 'Adjust sheet name
Set ws2 = Sheets("Sheet2") 'Adjust sheet name

lrow1 = ws1.Cells(Rows.Count, 1).End(xlUp).Row 'change the "1" to the column # of the beginning of the data set (defult is column A)
lrow2 = ws2.Cells(Rows.Count, 1).End(xlUp).Row + 1 'change the "1" to the column # of the beginning of the data set (defult is column A)

ws1.Range("A2:K" & lrow1).Copy Destination:=ws2.Range("A" & lrow2) ' Change the range to start cell of your data and the end column of your data (defult A2:K endrow of data)
End Sub

Read the comments and update the necessary code to match your data set.