Hi All,
I'm Working on the below macro and i have come up with the below questions.Kindly help.
1) Macro 1 (use column BF for the message)
a.if there are dupe vendor numbers(column C), and the corresponding bank records(column AF,AG) are unique, then it's ok, else fail
b.if there are dupe vendor names (column H), and the corresponding account group (column D) is different, then it is ok, else it's fail
2) Macro 2 (use column BG for the message)
a. if there are dupe vendor names (column H), if the vendor account group (column C) is either ZM05 or ZM14, then the country (column P) associated to it should be the same as the the country (column P) associated to ZM01. If fail, then mark all the lines failed
3) This is not a macro. I made a TRIM check on column BE, but it doesn’t work for some reason. I guess it has something to do with the “convert to numbers” thing
Lax
Bookmarks