wilkisa
Well-known Member
- Joined
- Apr 7, 2002
- Messages
- 657
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
We receive a large sheet from an outside source. It has 157 columns (A - FA), and 4041 rows.
The vendor name is in column C and the vendor address is in column D. I need a macro that will find duplicates and delete the entire row.
Example:
Col. C...Wonder Widgets...Col. D...123 Main
Col. C...Wonder Widgets...Col. D...456 Elm
Col. C...Wonder Widgets...Col. D...123 Main
I want to delete only the second occurance of Wonder Widgets at 123 Main. The other two Wonder Widgets should remain in the sheet.
Thanks in advance for any help,
Shirlene
The vendor name is in column C and the vendor address is in column D. I need a macro that will find duplicates and delete the entire row.
Example:
Col. C...Wonder Widgets...Col. D...123 Main
Col. C...Wonder Widgets...Col. D...456 Elm
Col. C...Wonder Widgets...Col. D...123 Main
I want to delete only the second occurance of Wonder Widgets at 123 Main. The other two Wonder Widgets should remain in the sheet.
Thanks in advance for any help,
Shirlene