VBA: Compare columns from different tables, copy the missing value to another table

[laalaa]

I have 1 table and 1 pivot table like as below picture,

Both of them have a column called "Name", i want to check if there're any name exist in Pivot Table but not Table 1 (i.e. John and Susan), I want them (just the names) to be copied to table 1. And I want this to be done whenever any change is made in the Pivot Table.

Can anyone help please?

 

[ZAX]

Hi Laalaa,
Please don't cross post cuz this is inappropriate, you posted the same exact post at Compare columns from different tables, copy the missing value to another table.
Please visit this website and read posting rules, hope you don't do that again my friend
Excelguru Help Site - A message to forum cross posters
ZAX

 

[RoryA]

Cross-posting is not against the forum rules. We only ask that you provide links to the cross-posts if you do so.

@ZAX,
Per rule 16, 'back seat moderation' is against the rules.

 

[ZAX]

Cross-posting is not against the forum rules. We only ask that you provide links to the cross-posts if you do so.

@ZAX,
Per rule 16, 'back seat moderation' is against the rules.

Sorry, Got the rules mixed with the other forum's rules, my fault

 

[RoryA]

The cross-posting rule is the same there too, actually.

 

[ZAX]

The cross-posting rule is the same there too, actually.

I meant about the "back seat moderation"

 

[RoryA]

The approach there is quite different to ours, yes.