I'd use Synkronizer (www.synkronizer.com) for this.
Recently released version 8 is ultra fast and good value for money.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(Spammastergrand) wrote:

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?