Automate deleting duplicate rows
 

In Excel 2000, is there a way to write a macro or something to automate the
deletion of duplicate rows in the spreadsheet? I'm new to visual basic, and
any help would be much appreciated. I delete dup rows on a weekly basis and
I'd like to try to save some time and be more accurate. Thank you for your
time...

Automate deleting duplicate rows
 

DataFilterAdvanced Filter

it has a unique rows facility.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"CMIConnie" wrote in message
...
In Excel 2000, is there a way to write a macro or something to automate
the
deletion of duplicate rows in the spreadsheet? I'm new to visual basic,
and
any help would be much appreciated. I delete dup rows on a weekly basis
and
I'd like to try to save some time and be more accurate. Thank you for
your
time...

Automate deleting duplicate rows
 

I do not see the unique rows facility...

"Bob Phillips" wrote:

DataFilterAdvanced Filter

it has a unique rows facility.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"CMIConnie" wrote in message
...
In Excel 2000, is there a way to write a macro or something to automate
the
deletion of duplicate rows in the spreadsheet? I'm new to visual basic,
and
any help would be much appreciated. I delete dup rows on a weekly basis
and
I'd like to try to save some time and be more accurate. Thank you for
your
time...

Automate deleting duplicate rows
 

Okay... I found it. I've never used advanced filter, so I will play around
with it. Thanks :)

"Bob Phillips" wrote:

DataFilterAdvanced Filter

it has a unique rows facility.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"CMIConnie" wrote in message
...
In Excel 2000, is there a way to write a macro or something to automate
the
deletion of duplicate rows in the spreadsheet? I'm new to visual basic,
and
any help would be much appreciated. I delete dup rows on a weekly basis
and
I'd like to try to save some time and be more accurate. Thank you for
your
time...