I'm having a big problem in Excel XP. I'm trying to write macros that compare
2500 rows in one sheet to 27,000 in another to see if there are duplicates.
I've tried loops, finds, even filters. The problem is its maxing the computers
resources with CPU usage going to 100% in Task Manager. In fact it freezes,
saying, Not responding, when looking at the process in Task Manager.

Even without programming this happens when I try to filter certain fields.
Anyone have any ideas? If the machine cant run the comparisions without locking
up people will have to manually check new data against 27,000 pre existing rows
to see if they are duplicates, updates, or new.

Also when I do a find, does looking in formulas intead of values speed it up?