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

Can anyone please help me with this..let me know if you need more details on that?

Adding additional information:

so basically we should check the column H first.
For instance if you found 3 similar match of "1ST MILESTONE LTD",
then first you should check if it has id in the column G, if not then "FAILED",
if there is Id, then you should check further if the corresponding records in the column G crosschecked with column D contains unique records only.

For example:


ZM01,396085586,1ST DEFENSE LTD
ZM07,396085586,1ST DEFENSE LTD
ZM11,396085586,1ST DEFENSE LTD

These 3 rows above should be "FAILED", because ZM01,07,11 have the same ID.

ZM01,396085586,1ST DEFENSE LTD
ZM07,396085587,1ST DEFENSE LTD
ZM11,396085588,1ST DEFENSE LTD


These 3 rows above should be "OK", because ZM01,07,11 have different IDs


I hope I could manage to explain it clearly.


Thanks,
Lax

Can some one please advice..

I tried with the below formula's and am failing..please help.

What am doing wrong...

Please Login or Register  to view this content.

Lax

Hi i applied this formula also..but im failing..Please help me

Please Login or Register  to view this content.

Lax

Dear Naveed,

Please leave all my query as it is not produce output..My requirement is below:

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"

Additional information:

so basically we should check the column H first.
For instance if you found 3 similar match of "1ST MILESTONE LTD",
then first you should check if it has id in the column G, if not then "FAILED",
if there is Id, then you should check further if the corresponding records in the column G crosschecked with column D contains unique records only.

For example:


ZM01,396085586,1ST DEFENSE LTD
ZM07,396085586,1ST DEFENSE LTD
ZM11,396085586,1ST DEFENSE LTD

These 3 rows above should be "FAILED", because ZM01,07,11 have the same ID.

ZM01,396085586,1ST DEFENSE LTD
ZM07,396085587,1ST DEFENSE LTD
ZM11,396085588,1ST DEFENSE LTD


These 3 rows above should be "OK", because ZM01,07,11 have different IDs

The solution either it may be a vba or formula..anythng is fine for me..Am pulling out my hair..i tried a lot.



Thanks in advance.
Laxman

I have attached the file in the Post#1..Same file..

Thanks Jaslake..It is working like a charm.Added reputation too.

Lax