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.