Excel Macro - Identify the differences in two different sales files

Macro to be written in the Personal File

First File is output from MYOB.

Second file is output from Ordermentum.

Compare the two files using invoice number is primary criteria.

- If there is a discrepancy in the final amount or tax amount, highlight the relevant row of the first file in red

(This includes cases where the item is not existing in the second file)

- If an item appears in the second file that isn't in the first, append it to the relevant invoice number section and highlight the row in red

- If an entire invoice number appears in the first file but not the second, highlight the section in red

- If an invoice appears in the second file but not the first, append details on a new worksheet called "Not Found"

Evner: Regnskab, Databehandling, Excel, Intuit QuickBooks, Visual Basic

Se mere: excel macro open files, excel macro open files directory, combine text files using excel macro, compare two excel sheets and highlight differences, how to compare two columns in different excel sheets using vlookup, how to compare two excel files 2010, compare two excel sheets and highlight differences macro, excel find matching values in two worksheets, compare two columns in excel for differences, how to compare two excel sheets for differences in values, best excel comparison tool, excel macro export text files, reading text files directory excel macro, import multiple text files excel macro, excel macro import project files, list files directory excel macro, excel macro create files, excel macro browse folder import files list, excel macro files directory, excel macro check excel files directory

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

Projekt ID: #18106386

Tildelt til:


Hello, thanks for inviting me to bid on your project and thanks for your trust and patience with me.

$100 AUD in 3 dage
(81 bedømmelser)

2 freelancere byder i gennemsnit $100 på dette job


Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Ok. Sure. Willing to take up your project. Thank you, Regards.

$100 AUD på 1 dag
(78 bedømmelser)