ave started using MYOB,, an accounting program that imports and exports data into excel.
Because MYOB has an grossly inadequate mobile phone app.(MYOB OntheGO)
I have had to use a different stand alone mobile invoicing program (MoblileBiz Pro, from Google Play store) which I am very happy with and which will export my sales data (invoices) into Excel.
I would like someone to write a Macro in Excel which will automatically change the MobileBiz data (tab delimited text, with headings) to a format that can be imported into MYOB. This mainly involves changing and matching heading names, and reformatting some other data .