Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked Workbooks - change in file location | Links and Linking in Excel | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
How to delete duplicates between workbooks? | Excel Worksheet Functions | |||
How to delete duplicates between workbooks? | Excel Worksheet Functions |