AHHHHH!

I am trying to do the following,

a) paste a load of email adresses from separate excel documents into a single column on a new doc (IT KEEPS SAYING THEY WONT PASTE BECAUSE THE AREA SIZE DOESN"T MATCH!!- GRR)

b) compare this composite column with another set of email adressess and filter out the ones which occur in both lists

is this possible? I am beyond frustrated...

please help.

sad times