maghari
10-13-2019, 11:20 PM
hi, experts
actullay i searched in internet but i don't reach to any result
let us get in subject i have three sheets the sheet1 contains table from a2: d15 of course the topics of headers begins a1: d1 and the same thing with sheet2 but the sheet3 from begin a2:e15 a2= numbering serials items here my problem when i transfer table1 from sheet1, to sheet3 it's normal but when i transfer table2 to sheet3 it also repeats topics of headers i don't need it
my images about file table1=sheet1,table2=sheet2,table3=sheet3
and this is my code
Sub CopyTables()
sheet1.ListObjects("Table1").Range.Copy _
Destination:=sheet3.Range("B1")
sheet1.ListObjects("Table2").Range.Copy _
Destination:=sheet3.Range("B4")
End Sub
actullay i searched in internet but i don't reach to any result
let us get in subject i have three sheets the sheet1 contains table from a2: d15 of course the topics of headers begins a1: d1 and the same thing with sheet2 but the sheet3 from begin a2:e15 a2= numbering serials items here my problem when i transfer table1 from sheet1, to sheet3 it's normal but when i transfer table2 to sheet3 it also repeats topics of headers i don't need it
my images about file table1=sheet1,table2=sheet2,table3=sheet3
and this is my code
Sub CopyTables()
sheet1.ListObjects("Table1").Range.Copy _
Destination:=sheet3.Range("B1")
sheet1.ListObjects("Table2").Range.Copy _
Destination:=sheet3.Range("B4")
End Sub