Automate deleting duplicate rows

C

CMIConnie

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...
 
B

Bob Phillips

Data>Filter>Advanced Filter

it has a unique rows facility.

--
HTH

Bob Phillips

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

CMIConnie

I do not see the unique rows facility...

Bob Phillips said:
Data>Filter>Advanced Filter

it has a unique rows facility.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
C

CMIConnie

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