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
|