find duplicates across two different tables

Hi all,

I'm brand new and hoping someone can help with a bit of a problem I have.
I'm quite new to excel and also to this forum, so if this is mega easy and I'm being terribly dense I do apologise.
I'm running Microsoft Office 2007.

I have 2 separate tables.. both a list of contacts of sorts.
In one table I have a list of all my clients (table A), in the other I have a list of "preferred" clients (table B).

The contact details etc that are stored in table A are more comprehensive to those in table B.
Effectively, I want to search for all of my preferred contacts from table B and filter for them in table A.
Then ideally i will sort alphabetically and just cut and paste the details into my preferred client spreadsheet.

Is there a way of doing this?
I had a look online and there was something about creating a "relationship" but I don't think excel 2007 allowed me to do it. I certainly hadn't heard of powerview or powerpivot that they were using!

Hope someone can help.
Thanks for your time.

Matt

Hi,

I'm pretty confident that I know a way of making this happen for you, but could you please upload your workbook for me to take a look at?

Thanks

Hi there,
Thanks for looking and it would be great if you could help.
For data protection I cant upload the specific workbook, but I will upload an example and hopefully that will work?
I have uploaded the files in CSV (as that's what the original doc needs to be)
Any help you can give you be amazing!
Cheers,
Matt

No worries, I can work with examples

I have put together a simple spreadsheet that can be made fancier if need be, but at the moment it just demonstrates functionality (hopefully the same functionality that you were hoping for).

For it to work, the "SortContacts.xlsm" needs to be in the same Windows directory as "table A.csv" and "table B.csv" (or whatever files you have specified in the purple cells on the "Setup" worksheet). Once you have specified the 2 files, press the button and hopefully you are given the result you were looking for.

I hope this helps

I just realised, that going back to your OP, this doesn't sort or anything fancy yet, it just extracts the list from table B and populates with the relevant data from table A.

Just let me know if I'm on track and then I can help perfect it later anyway

I had a quick go at this but couldn't get it working right for some reason
im nipping out to a meeting just now and then can have proper look later
thank you so much for helping with this
im not too computer savvy so expect i'll just need to read your instructions better on my return!

cheers,
matt

OK let me know how you go