Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
exel macro to eliminate duplicate record
It's been quite a few years since I've had to use macros.
But now I'm stuck. I have several large worksheets that are the result of merged databases and I would like to use a macro to eliminate duplicate records. This is following a sort where I can clearly see one row and the one beneath it has the duplicate data. Any suggestions please!!!! Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
exel macro to eliminate duplicate record
Sub DeleteDups()
do while ActiveCell < "" if activeCell.Value = activecell.Offset(1,0).Value then ActiveCell.Offset(1,0).EntireRow.Delete else ActiveCell.Offset(1,0).Select end if Loop End Sub Select the first cell in the column you want to check and run the macro. Untested, but should work. Test it on a copy of your workbook. -- Regards, Tom Ogilvy "FSK- in montreal" wrote in message ... It's been quite a few years since I've had to use macros. But now I'm stuck. I have several large worksheets that are the result of merged databases and I would like to use a macro to eliminate duplicate records. This is following a sort where I can clearly see one row and the one beneath it has the duplicate data. Any suggestions please!!!! Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
exel macro to eliminate duplicate record
Thanks Tom!!
-----Original Message----- Sub DeleteDups() do while ActiveCell < "" if activeCell.Value = activecell.Offset(1,0).Value then ActiveCell.Offset(1,0).EntireRow.Delete else ActiveCell.Offset(1,0).Select end if Loop End Sub Select the first cell in the column you want to check and run the macro. Untested, but should work. Test it on a copy of your workbook. -- Regards, Tom Ogilvy "FSK- in montreal" wrote in message ... It's been quite a few years since I've had to use macros. But now I'm stuck. I have several large worksheets that are the result of merged databases and I would like to use a macro to eliminate duplicate records. This is following a sort where I can clearly see one row and the one beneath it has the duplicate data. Any suggestions please!!!! Thank you . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
exel macro to eliminate duplicate record
There's really no need to make cells active this way - unless you like to
see the screen updating. Sub Delete_Row() Dim target as range set target = activecell Do If Target.Value = Target.Offset(1, 0).Value Then Target.Offset(1, 0).EntireRow.Delete Else Ste target = target.Offset(1, 0) End If Loop While target.value< "" End Sub -- Patrick Molloy Microsoft Excel MVP --------------------------------- I Feel Great! --------------------------------- "Soo Cheon Jheong" wrote in message ... Try Sub Delete_Row() Do If ActiveCell.Value = ActiveCell.Offset(1, 0).Value Then ActiveCell.Offset(1, 0).EntireRow.Delete Else ActiveCell.Offset(1, 0).Select End If Loop While ActiveCell < "" End Sub __ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminate Duplicate Row | Excel Discussion (Misc queries) | |||
how to eliminate duplicate numbers | Excel Worksheet Functions | |||
Eliminate duplicate values in drop down list | Excel Discussion (Misc queries) | |||
Eliminate Duplicate Rows - Add columns Accordingly | Excel Discussion (Misc queries) | |||
How to eliminate duplicate entries | Excel Discussion (Misc queries) |