Finding unique data between two diffrent spreadsheets

I have two spreadsheets that has names and phones and addresses in it. The diffrent sheets were created for diffrent reasons that have duplication of information, but now I would like to sort the duplicate data out (between the 2 sheets) and have a new sheet with just data that was not on both. Can anyone help?

Corey

Have a look at vba HELP for FINDNEXT

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"bigdogcc" <bigdogcc.26j3kb_1145478901.2107@excelforum-nospam.com> wrote in
message news:bigdogcc.26j3kb_1145478901.2107@excelforum-nospam.com...
>
> I have two spreadsheets that has names and phones and addresses in it.
> The diffrent sheets were created for diffrent reasons that have
> duplication of information, but now I would like to sort the duplicate
> data out (between the 2 sheets) and have a new sheet with just data
> that was not on both. Can anyone help?
>
> Corey
>
>
> --
> bigdogcc
> ------------------------------------------------------------------------
> bigdogcc's Profile:
> http://www.excelforum.com/member.php...o&userid=33661
> View this thread: http://www.excelforum.com/showthread...hreadid=534345
>

is there a way without the vb? I am very new to vb