Announcement

Collapse
No announcement yet.

Compile Two Tables to One

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Compile Two Tables to One



    Hello, experts,

    I Need help to compile two tables in different sheets into one, merged table.
    I'll illustrate below:
    Table 1
    Data1 Owner
    A x
    B x
    C x
    D x
    E x
    J y
    K y
    L y
    M y
    Table 2
    Data2 Owner
    a x
    b x
    c x
    a y
    b y
    so it will result like this:
    Table Result
    Data1 Data2 Owner
    A a x
    B b x
    C c x
    D x
    E x
    J a y
    K b y
    L y
    M y
    Please help for the macro. I'm actually not a programmer here so I hardly know how to create such.
    Thanks.
Working...
X