Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete row where there is duplicate data in Column E
I have a report I download every day and each day the row count is different.
I need to perform all kinds of editing so that I can run this spreadsheet against another spreadsheet. I created a macro to perform most of the editing and have my page setup, header, footer, font all set in that macro. Now I want to add code that looks for duplicate entries in Column E in 2 consecutive rows, anyplace in the document, and if found delete the first of the two rows. Normally there are about 10 of these duplicate rows where I need to delete the first on of every time it occurs, is this even possible. Thanks so much |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Delete row where there is duplicate data in Column E
Hi SITCFanTN,
See response to your latest thread. --- Regards, Norman "SITCFanTN" wrote in message ... I have a report I download every day and each day the row count is different. I need to perform all kinds of editing so that I can run this spreadsheet against another spreadsheet. I created a macro to perform most of the editing and have my page setup, header, footer, font all set in that macro. Now I want to add code that looks for duplicate entries in Column E in 2 consecutive rows, anyplace in the document, and if found delete the first of the two rows. Normally there are about 10 of these duplicate rows where I need to delete the first on of every time it occurs, is this even possible. Thanks so much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
delete duplicate names in a column | New Users to Excel | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |