Maybe you could use data|filter|advanced filter.

Debra Dalgleish has some notes at:
http://contextures.com/xladvfilter01.html#FilterUR

JVDM wrote:

I need to filter out information from 1 sheet to another to take out
duplication. Does anyone have a formula that I can use?? I need it to sort
out 2 columns of information. Thanks for the help!

--

Dave Peterson