Hi All,
I'm looking for a macro that searches unique values in two tables and copies those values to another table.
If I add values to one of both tables, only the new unique values are copied.
Example and more detailed info attached.
Thanks!
I've first tried it manually:
Copy and paste both tables to new worksheet below each other.
Remove duplicates and then copy these unique values to another table.
DISADVANTAGE: every time I run the macro, All values needs to be re-calculated every time the macro is run.
I'm talking about >20 000 values.
If you would like more info, please let me know.
Bookmarks