Combine Two Tables into One that Includes All Unique Data from Each Source Table

[chasescresties]

Hi All,

I currently have two tables that are on separate worksheets in the same workbook. I want to combine them onto a third worksheet in that same workbook. When I say combine, I mean literally stack one right on top of the other*. Both tables have the same column headers, but all of the data is unique to its respective table. I understand that this is a simple copy and paste thing. The catch is that I want the third table to be linked to the source tables so that when the source data is changed, the third table automatically updates to show the new changes.

*"Stacking" Example:

Table 1:
A B C D
1 2 3 4
5 6 7 8

Table 2:
A B C D
9 8 7 6
5 4 3 2

Table 3 (Combined):
A B C D
1 2 3 4
5 6 7 8
9 8 7 6
5 4 3 2
​

Anyone able to help with this?

 

[bs0d]

You could paste in the 2nd table, then use the Data --> Remove Duplicates function?

 

[chasescresties]

To get the data to the third table? Of course! But that still doesn't solve the linking/auto-updating problem.

 

[bs0d]

Ok. Click Record Macro. Run the remove duplicates function. Then select the data, copy, paste. Stop recording. Then run this macro each time you need.

 

[chasescresties]

I will try that. Thank you!