Deleting Duplicate Row as per the column status

**daksh1981** · 08-05-2009, 11:35 AM

Please help me on this. I have two sheets “Day Log” and “Pend Case”, please find the attached sheet for reference. After my day’s work finishes I push all my cases into “Pend Case” sheet so that I can pull these cases next day. My VBA code for Push & Pull Cases are working fine but I have stuck in below:
I want that when I click on “Pull Case” button, it should first look for duplicate case values in the list “B2:B12” in “Pend Case” sheet & then it should delete all duplicate cases who has Case Status as New Case.

**daksh1981** · 08-07-2009, 09:47 AM

In addition to the above scenario. I want that VBA code should only retain the Last "Follow Up" occurance only. like:

Case Number Case Status
C-121 New Case
C-124 New Case
C-125 New Case
C-121 Follow Up
C-121 Follow Up

In the above scenario I want that only the last occurance of Case Number C-121 should retain & all above occurance should be deleted.

**daksh1981** · 08-12-2009, 01:44 PM

Hi, Any one please help me...

**royUK** · 08-12-2009, 02:03 PM

You could possibly use Advanced Filter -. Unique value & copy to another location. Finally delete the originals.

**daksh1981** · 08-13-2009, 04:34 AM

I tried this also but could not able to do so. My problem is that I want to delete duplicate rows as per the value in two columns for example in my attached sheet: I want to delete all rows which has "Case Number" as "C-121" and "Case Status" as "New Case", I don't want to delete Case Number "C-121" & Case Status as "Pending Information from Landsafe". Same with other case numbers.
Please help me out to crack this.