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.
Bookmarks