Hi All,

I currently have is two spreadsheets (two different depts.) with, in some cases the same clients on each, each client have a dedicated ID made up of initials, DOB and Postcode (A/B-10/10/72-CV4/4RT).

What I'm trying to do is combine both spreadsheets dataset onto one, based on the ID and all the ones who aren't on both are preferably left off the new spread sheet.

Many thanks

Clash