Easiest and Best way possible

[TimBrowne]

Hello,

Within a sheet I am creating I get several Data, which should at a certain point be joining together bases on a Unique value (registration number), now I am trying to find the easiest way to do this automatically

What I have: 1 macro importing date from 2 different sources
Tab 2 all information source one
Tab 3 all information source 2
All data is different (consider the sources to be a registration system and a payment system), except 2 values, Full name and User ID.
Now on tab 1 I want to reflect the Unique values, meaning;
If someone is mentioned only on TAB 2 it appears.
If someone is only mentioned on TAB 3 it appears.
If someone is mentioned on both tabs it appears only once.
If on any of the TABS (2 or 3) or together someone is mentioned twice I want him to appear on the list only once.

Once I have the names once I can create Vlookups to insert further data and let the table see from which sheet the name comes.

Hop this is clear enough (and possible)

Thank you!

Tim

[Special-K]

Rule 1
http://www.excelforum.com/forum-rule...rum-rules.html

[TimBrowne]

Sorry can not change title anymore. Will delete and start again.

[Special-K]

Contact a mod, they'll probably change it for you.