Load data's Update for multiple records using vba

Hi There,

Good evening all,

Like i have been allocated to work on the below item..i tried in one module,but am failing..below is my requirement.


So there are two things i have to do using vba macros..

1) the vendors (rows) in this sheet should be checked by the following condition:
vendors with ZM01, ZM07, ZM11 account group (column D) should not have the same DUSN number (column G). You can use column H for the vendor comparision. Unfortunately at this point we don't have unique ids If it has then make all the rows for that vendor "FAILED"
2) this is the harder one. We should check if the vendor names are the same or not. If not, then "FAILED"


Kindly help me with recoding vba for the scenario..

Attaching the file for referncce

lax