hi guys,...
I desperetely need a big macro(script) smt. like this;
have two different *.xls files, macro will ask which; and open the first & second
files, it will also ask which columns are the "name" columns or detect them...

in first file , lets say a-b-c-d-e columns are full and some are numbers, and
column b has ; "name-surname" records of 2000 persons...

second file, nearly the same, but 1000 records....

now, I need the macro to open an 3rd. sheet which contains the differences;
the names in 1000 records (2nd file), but not in 2000 records (1st file)...

names are composed of text including space , like "John Smith", they may
be also misstyped; as "Jonh Smiht" ....

so , this macro should "feel" that this two are the same

also , articles; like "the, on, of, from,etc..." should not be taken into
consideration....

so long this far,...but a big macro.....
tnx for your helps.