ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Finding unique data between two diffrent spreadsheets (https://www.excelbanter.com/excel-discussion-misc-queries/84074-finding-unique-data-between-two-diffrent-spreadsheets.html)

bigdogcc

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


--
bigdogcc
------------------------------------------------------------------------
bigdogcc's Profile: http://www.excelforum.com/member.php...o&userid=33661
View this thread: http://www.excelforum.com/showthread...hreadid=534345


Don Guillett

Finding unique data between two diffrent spreadsheets
 
Have a look at vba HELP for FINDNEXT

--
Don Guillett
SalesAid Software

"bigdogcc" wrote in
message ...

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




bigdogcc

Finding unique data between two diffrent spreadsheets
 

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


--
bigdogcc
------------------------------------------------------------------------
bigdogcc's Profile: http://www.excelforum.com/member.php...o&userid=33661
View this thread: http://www.excelforum.com/showthread...hreadid=534345



All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com