On Friday, July 27, 2012 10:59:44 PM UTC+3, wrote:
On Sunday, July 22, 2012 12:13:01 PM UTC-4, Ejire wrote: I have an Excel macro which works well in comparing two columns A and B. it populates column C with unique values in A and not in B, populates column D with unique values in column B and not in A and puts the values found in both A and B in the fifth column (E). Data in the columns A and B of Sheet 1 has exceeded 1,048,576 (the maximum allowable in Excel 2007) and i will copy the overflow data in Sheet 2's column A and B and i will like the comparison to continue in the next worksheet. I need the macro to treat the second worksheet as a continuation of the first sheet and not as a separate data. (The values i am comparing have exceeded 1million) Kindly assist with the modification on the attached macro that will perform this. +-------------------------------------------------------------------+ |Filename: Compare two columns.txt | |Download: http://www.excelbanter.com/attachment.php?attachmentid=487| +-------------------------------------------------------------------+ -- Ejire I agree with pascal in that Access is far better suited for this than Excel, however, Excel can do it. Create a second range defined on the second worksheet. After the process finishes with the first range, it then steps through the second range. M

Do you think that excel eork fast with 130000 row * 30 columns ?