Завершено

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.

Квалификация: Бухгалтерия, Обработка данных, Excel, Архитектура ПО, Visual Basic

Показать больше 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

О работодателе:
( 11 отзыв(-а, -ов) ) ERMINGTON, Australia

ID проекта: #18282403

Поручен:

supper5guy

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

$100 AUD за 3 дней(-я)
(81 отзывов(-а))
5.7

7 фрилансеров(-а) в среднем готовы выполнить эту работу за $137

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 Больше

$200 AUD за 5 дней(-я)
(168 отзывов(-а))
7.4
zebracaro

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

$150 AUD за 3 дней(-я)
(119 отзывов(-а))
6.7
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 Больше

$150 AUD за 3 дней(-я)
(18 отзывов(-а))
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 за 3 дней(-я)
(41 отзывов(-а))
4.5
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 за 7 дней(-я)
(1 отзыв)
1.1
MgtEng

Hi, I can do the Macro with the comparisons, computations etc. Drop me a text with the files to be selected, files with values that need to be used in the Macro, I will send you a test version tonight. Let me kn Больше

$133 AUD за 3 дней(-я)
(1 отзыв)
2.9