ID location of duplicates in different workbooks.
 

I have another question for you folks. So far so good, all of the
advice I have received has been very helpful.


We had a large workbook filled with data that looks something like
this:

Form# Date Comment Seq
11-1021212 2000/01/01 Comment 1
11-1021212 2000/01/01 Comment 2
11-1021212 2000/01/01 Comment 3
11-1021212 2000/01/01 Comment 4
11-1021212 2000/01/01 Comment 5
11-1021214 2000/01/01 Comment 1
11-1021214 2000/01/01 Comment 2
11-1021214 2000/01/01 Comment 3
11-1021214 2000/01/01 Comment 4
11-1021214 2000/01/01 Comment 5


What we have done with this is categorize it based on the comments,
selecting all of the rows associated to a from number and pasting them
in onto a different work sheet.


This is where the trouble starts.....

TO make this a bit easier, we took a large database and split it in 2
pieces (there were about 10,000 rows) When this was split, someone
forgot to sort the records by form#, now duplication exists in the 2
workbooks.


Is there any code that could identify for us IF a duplicate exists...
i.e. it is in both workbooks.....what sheet and cell location it is??



thanks in advance for your assistance.

ID location of duplicates in different workbooks.
 

Chip Pearson's page on working with duplicates and uniques should give you
some ideas:

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy

"John Fevens" wrote in message
om...
I have another question for you folks. So far so good, all of the
advice I have received has been very helpful.


We had a large workbook filled with data that looks something like
this:

Form# Date Comment Seq
11-1021212 2000/01/01 Comment 1
11-1021212 2000/01/01 Comment 2
11-1021212 2000/01/01 Comment 3
11-1021212 2000/01/01 Comment 4
11-1021212 2000/01/01 Comment 5
11-1021214 2000/01/01 Comment 1
11-1021214 2000/01/01 Comment 2
11-1021214 2000/01/01 Comment 3
11-1021214 2000/01/01 Comment 4
11-1021214 2000/01/01 Comment 5


What we have done with this is categorize it based on the comments,
selecting all of the rows associated to a from number and pasting them
in onto a different work sheet.


This is where the trouble starts.....

TO make this a bit easier, we took a large database and split it in 2
pieces (there were about 10,000 rows) When this was split, someone
forgot to sort the records by form#, now duplication exists in the 2
workbooks.


Is there any code that could identify for us IF a duplicate exists...
i.e. it is in both workbooks.....what sheet and cell location it is??



thanks in advance for your assistance.