Edit: deleting duplicate files from Excell

[Habitat for Humanity]

Can anyone tell me how to delete multiple files in an
Excell worksheet when the Name and Address (ADD2) are the
same, but other fields differ. It is a very large
database with many
multiple files and was wondering if there was a macro i
could run
Thank you
Gloria at Habitat for Humanity

 

[Dave Peterson]

I bet you don't really mean multiple files.

But Chip Pearson has a bunch of techniques (including macros) at:
http://www.cpearson.com/excel/duplicat.htm