Have duplicate rows of data

H

homer985

I have a database in Excel format that I need to trim down. There are
duplicate "entries", with identical information by rows. Is it possible
to have it automatically trimmed, deleting the duplicate rows?

I have 2,100 rows of data, many of which are duplicate. Just want to
trim that down...

Thanks,
Dave
 
H

homer985

Thanks Frank, that look like EXACTLY what I need. My computer knowledge
is good, but my experience with macro's is limited. Obviously I'll need
to cut and paste the macro commands... any suggestions on putting into
to my database/workbook.

Any help will be appreciated.

TIA
 
F

Frank Kabel

H

homer985

Thanks Franks once again! You da man. Worked like a charm, and you save
me a couple of hours of work from going through thousands of repeate
entries.

Dav
 
Top