Find Jobs
Hire Freelancers

FUH - Write a Macro to compare the output of MYOB Sales to the output of Ordermentum Payments

$30-250 AUD

Completed
Posted over 5 years ago

$30-250 AUD

Paid on delivery
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.
Project ID: 18282403

About the project

6 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello Mate, thanks for this new project. Please send over the necessary documents. Thanks and waiting
$100 AUD in 3 days
5.0 (84 reviews)
5.8
5.8
6 freelancers are bidding on average $137 AUD for this job
User Avatar
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
$200 AUD in 5 days
5.0 (227 reviews)
7.9
7.9
User Avatar
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
$150 AUD in 3 days
4.9 (129 reviews)
7.1
7.1
User Avatar
"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"
$150 AUD in 3 days
5.0 (20 reviews)
4.7
4.7
User Avatar
Hello, I am very familiar with Excel and Data process, no matter whether it is Data analysis report or pivot chart report, I hope you can choose me.
$124 AUD in 7 days
4.8 (4 reviews)
3.9
3.9
User Avatar
Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.
$100 AUD in 3 days
4.4 (48 reviews)
4.6
4.6

About the client

Flag of AUSTRALIA
ERMINGTON, Australia
5.0
14
Payment method verified
Member since Jul 4, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.