Guys ..Kindly,can you please help me or give me root to solve this problem. Waiting for your valuable comments. Lax
On Tuesday, November 11, 2014 1:27:54 PM UTC+5:30, Laxmanan M wrote: > Hi All, > > Need help to complete my task using vba.Thanks in advance..Attaching the > workbook here for review. > > > 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 > > > > Thanks, > > Lax > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
