FUH - Write a Macro to compare the output of MYOB Sales to the output of Ordermentum Payments
$30-250 AUD
Slutfört
Publicerad över fem år sedan
$30-250 AUD
Betalning vid leverans
Active Sheet = MYOB Sales Report
Run Macro
User is prompted to select the Ordermentum Payments File
Macro will then:
- Match up OMO numbers between Files.
- When a match is found, compare the dollar amounts
- If the dollar amounts match, highlight the row in specific Green
- If the dollar amounts do NOT match, highlight the row in specific red
- Insert the "Batch" number in Column G to the right of the matched OMO/Amount
- All green rows per customer to be grouped together and in order of ascending date, above any non-matched OMOs.
- Insert total of matched OMO/Amounts beneath the green block per customer. Highlight cell in specific Blue.
- Create New Worksheet in same Workbook
- Create a tally table in the new worksheet according to provided format
END.
Dear Employer,
I understand what you are asking. I just need the files in which you need this and a little discussion on few points. please message me, I am an expert and will provide a quality deliverabble
Thanks and Regards,
Ash
"Hello Dear,
Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as keep you returning consistently. It is because of the importance behind this field that I am confident & serious when taking these types of projects. Let me introduce with professionalism and skill that exists to supply the best. Regards"