[solved]-Using Vba Need Delete Recent Instance Account Number Accountno Contract Date 999999 2 15 2 Q39061959

using vba i need to delete ONLY the most recent instance of anaccount number

accountNo contract date

999999 2/15/2019

999999 1/15/2019

999999 12/15/2018

888888 2/20/2019

888888 1/20/2019

so in this case i would only need to delete from theworksheet

999999 2/15/2019

888888 2/20/2019

because they are the most recent

Expert Answer

---

Answer to using vba i need to delete ONLY the most recent instance of an account number accountNo contract date 999999 2/15/2019 9… . . .