VBA Copy table columns to another table last row

[Melimob]

HI

I really tried (and failed) ..

I want to copy and paste from one table on one sheet... to another table on another sheet adding the data to specific columns.

I.e

Copy from:
Table11
A:J

Copy certain columns to specific columns in other table

Paste to:
Table10
B,C,E,G..

I tried to say, add a row to last row of my table
value from table11 = value to table10

It would be all the rows adding from table11 to table10

I tried with below code but no luck? any help appreciated..

Sub AddNonCCB()


Dim ABCD As Worksheet
Dim tblABC As ListObject
Dim tblrow As ListRow


Set HRGC = Sheets("ABCD Clients ")
Set tblHRG = ABCD.ListObjects(1)
Set tblrow = tblABC.ListRows.Add


tblrow.Range(1, 1).Value = Sheets("ImportNonCCB").Range("Table11[ABC Client Name]").Value


End Sub