View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Compare two spreadsheets and eliminate duplicates

You objective is not clear.

1. Do you have duplicates in Column B of worksheet 1?
2. Do you have duplicates in Column A of worksheet 2?
3. If yes to 1 & 2 above, do you want to delete the entire row for each
duplicate found?
4. Assuming you mean by "output" that you want the duplicate items recorded
on a third worksheet, do you want the entrie row for each item or just the
data from the duplicate cell of column B or A respectively?
5. Is Sheet3 in the workbook empty or will a new sheet be needed as the
third sheet in this exercise?




"Joe_Hunt via OfficeKB.com" <u45578@uwe wrote in message
news:a6215ce018db5@uwe...
I would imagine this is in here somewhere, but I haven't found it, and
can't
get it to work on my own. I have two spreadsheets that I've put in the
same
workbook. I want to be able to eliminate the duplicates from the first
spreadsheet and make the output into a separate worksheet in the same
workbook. The data I'm comparing are in column B on the first worksheet
and
can go to several thousand rows, and column A on the second that can go to
maybe 20,000 rows or so. I really appreciate your help. I could do it in
Access, but if a simple VBA solution is available this would be faster
since
I'd need to put it back into Excel anyway. Thanks again.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201004/1