Help on VBA Code....

[daksh1981]

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.

[mudraker]

Please take a couple of minutes and read ALL the Forum Rules (Rule 1) then start a new thread with a title that it better discribes your problem/request