I can’t figure out how to do that as I have only a basic grasp of VBA code. Just an idea - if this could be modified to delete the entire row based on columns selected, that would be perfect. The problem is that it only deletes the relevant cells when I run it on columns B&C and not the entire row. This macro below almost does what I want it to do because it somewhat open-ended since it works with the range you highlight. Unique items are those which do not have the exact same information in both column B & C. I’d want to retain the items without the “location ID” since they are newer. Sorting the list as a part of the macro would make that impossible. I thought I'd keep those "bad" records at the very top of the list so that when duplicates are searched for, the imported entries (the ones without location IDs) get removed if they share the same name & address. I'd prefer if the tables weren't re-sorted because, the list in its entirety, contains a set of rows I'd highlighted as "bad" - I don't want their information reintroduced into the list since I know they've closed or moved locations. Re: Macro for: Deleting entire rows based on duplicate information in two columns? If cell.Offset(0, 1) = cell.Offset(1, 1) And cell.Offset(0, 2) = cell.Offset(1, 2) Then ' For speed purposes use clearcontents and then resort list ' Remove duplicate entries ( Name / Address determine duplicate entries ) ' Sort the table by NAME / Address ( Street ) ' Set the data range ( based on "NAME" field ) I've attached a sample of what I'm working with. It's a tedious process to do manually remove entire rows (for duplicate column B&C) when dealing with thousands of rows and I would very much appreciate any assistance or insight into how simplify the process with a macro. The ones that I’ve played with unfortunately end up deleting the cells only and not the entire row. I import new store records all the time and many are invalid because they share the same name and street address and therefore need to be removed. Store Name (column B), Street Name (column C), State/Province, etc.
I'm dealing with a worksheet with store record information. I need a macro that removes an entire row when: information in column B and column C are both found in other rows (duplicates). Maybe someone could help me out? It's pretty straightforward situation. I've been looking through various forums looking for a macro for a particular task, but I have not found something that works yet.
0 kommentar(er)
