Deleting duplicate numbers between two worksheets

[redsquad3]

I'm trying to get a vba code that would compare the numbers in the WorkOrder column in the WO worksheet to the numbers in the SO# column in the SO worksheet and delete any duplicate numbers that are present in both columns from the SO# column and then display a message saying how many unique values are left in the column. In the WO sheet I have a dataset consisting of about 70,000 numbers and in the SO sheet I have a dataset of about 5,000 numbers and the code I wrote doesn't run for this large dataset as excel stops responding. Any help would be appreciated. Capture.5PNG.PNG Capture6.PNG

[karedog]

Not too sure, so I will make the subs in steps :

Please Login or Register  to view this content.

The steps :
1. Run sub Main1
2. Run sub Chk1 --> this will check wheter macro calculation is same with using Excel's formula
3. Manually compare the result between both methods
3. Run sub Chk2 --> this will convert the Excel's formula to value (we will delete a lot of rows, so converting to value will make the process much faster)
4. Run sub Main2 --> this will delete duplicated values

If this is what you actually wanted, then for the next job, just run sub Main1, then followed by sub Main 2 (no need to run Chk1 and Chk2 anymore)

[Marc L]

No duplicate in attachment !

Better is to post a before workwook with duplicates at least and an after workbook as expected result …