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"