I wish I could record the macro but this one is different and I don't know
how to record it. I had to do it manually because I had to get the job done
before the end of the day. So, it's all done now. Some of the worksheets
were over 2000 rows. However, I sure would like to know how to do it for
future projects. I will read on up the link you sent. I have used the
filter but not on something like this.

"Gord Dibben" wrote:

Connie

You don't need a macro for this.

You can use DataFilterAdvanced Filter to select unique records.

See Debra Dalgleish's site for more info.

http://www.contextures.on.ca/xladvfi....html#FilterUR

If you want a macro, record one while going through the steps.


Gord Dibben Excel MVP


On Fri, 18 Nov 2005 08:35:46 -0800, "Connie Martin"
wrote:

I need another macro! Boy, I wish I knew how to write these wonderful
things! In the sample below I need a macro that will delete the entire rows
where the data is repeated in a given column---that is, that it would delete
the repeat ones, leaving one of them. In this example, in the first set, all
that should be left are two rows which contain ME22N and MR8M in column E.
ME22N is repeated two more times and those rows need to be deleted. If I
could get a macro that would ask for the column to operate in, that would be
great for other spreadsheets where it would not necessarily be column E.

A B C D E
MACLEOL Lynn MacLeod P0040104 ME22N
MACLEOL Lynn MacLeod P0040104 ME22N
MACLEOL Lynn MacLeod P0040104 ME22N
MACLEOL Lynn MacLeod P0040104 MR8M

MACLEOL Lynn MacLeod P0050006 MB0A
MACLEOL Lynn MacLeod P0050006 MB0A
MACLEOL Lynn MacLeod P0050006 MB0A
MACLEOL Lynn MacLeod P0050006 ME21N
MACLEOL Lynn MacLeod P0050006 ME21N
MACLEOL Lynn MacLeod P0050006 ME21N

MACLEOL Lynn MacLeod P0050008 ME21N
MACLEOL Lynn MacLeod P0050008 ME21N
MACLEOL Lynn MacLeod P0050008 ME21N
MACLEOL Lynn MacLeod P0050008 MIGO
MACLEOL Lynn MacLeod P0050008 MIGO
MACLEOL Lynn MacLeod P0050008 MIGO
MACLEOL Lynn MacLeod P0050008 MIGO