Trying to create Macro to delete duplicate Rows
 

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

Trying to create Macro to delete duplicate Rows
 

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

On May 8, 11:42*am, Dennis wrote:
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

Trying to create Macro to delete duplicate Rows
 

See:

http://www.cpearson.com/excel/deleti...eDuplicateRows
--
Gary''s Student - gsnu200784


"Dennis" wrote:

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