Færdiggjort

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

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.

Evner: Regnskab, Databehandling, Excel, Software Arkitektur, Visual Basic

Se mere: myob online, myob accountright premier, myob accountright pricing, myob pricing, myob essentials pricing, myob accountright subscription, my myob, myob software, excel macro compare table, excel macro compare tables, excel macro compare rows, write macro export sql, write macro automatically forward email outlook, write macro cut paste excel, write macro search find, write macro outsource, write program compare integers larger, write macro excel lotto, write macro outlook 2007, excel macro compare copy

Om arbejdsgiveren:
( 14 bedømmelser ) ERMINGTON, Australia

Projekt ID: #18282403

Tildelt til:

supper5guy

Hello Mate, thanks for this new project. Please send over the necessary documents. Thanks and waiting

$100 AUD in 3 dage
(84 bedømmelser)
5.8

6 freelancere byder i gennemsnit $137 på dette job

asin1987

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 Thank Flere

$200 AUD in 5 dage
(227 bedømmelser)
7.9
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$150 AUD in 3 dage
(129 bedømmelser)
7.1
dataexplorer

"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 Flere

$150 AUD in 3 dage
(20 bedømmelser)
4.7
bruceci

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 dage
(4 bedømmelser)
3.9
prasannjeetp

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 dage
(48 bedømmelser)
4.6