Results 1 to 11 of 11

Thread: help adjusting code combine two tables from two sheets to another sheet

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    help adjusting code combine two tables from two sheets to another sheet

    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
    HTML Code:
    Sub CopyTables()
        sheet1.ListObjects("Table1").Range.Copy _     
              Destination:=sheet3.Range("B1")
    
        sheet1.ListObjects("Table2").Range.Copy _        
              Destination:=sheet3.Range("B4")
    End Sub
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •