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"
3 freelancere byder i gennemsnit $150 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.