VBA not working after data change

[kirana2014]

Dear all,
could you Please help to edit this macro,
after I change de data de macro not working anymore

Could you please check the date after macro run the date must be :

dd-mm-jjjj uu:mm not mm-dd-jjjj uu:mm

ID Name Date en Time Amount
123 Wayan 2-10-2021 18:33 140
110 Made 2-9-2021 14:34 20

Must be

ID Name Date en Time Amount
123 Wayan 10-2-2021 18:33 140
110 Made 9-2-2021 14:34 20

Please Login or Register  to view this content.

[maras_mak]

Try.

Please Login or Register  to view this content.

[kirana2014]

Dear all,

the macror need to check the duplicate value in "B" instead of "A"

Please help

Thank you

[maras_mak]

Try.

Please Login or Register  to view this content.