To delete duplicates..........DataFilterAdvanced Filter.

Check unique records and copy to another location.

Why do you get a new worksheet every time you import from yahoo?

Depends upon your import method.

How are you currently doing it?


Gord Dibben MS Excel MVP

On Sat, 23 Jan 2010 06:44:01 -0800, donald
wrote:

imported yahoo address book, to many times. need to delete all but one.
also, why do I get a new worksheet everytime I import to excell from yahoo?
thank you,