Trying to create Macro to delete duplicate Rows

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

Hello,

I am hoping someone can help me. I am not an experienced macro writer and I
am having a problem on how to write a macro on deleteing duplicate rows. To
give you an example of what i am trying to do is:

I am trying to delete rows with duplicate information that is in column
A,S,T,U,V,W, Y, and Z.

But i want to leave at least one row with that info.

For example if row 1, 2, and 3 have the same info in A, S, T, U, V, W, Y,
and Z. I would want to leave row 1 and delete row 2 and 3.

I am hoping someone can help.

Thanks
 
Hi
This is one of the most common questions asked. Please search this
group with "delete duplicate rows" and you will see many hundreds of
past emails to work from.
regards
Paul
 
Back
Top