Attached is an Excel spreadsheet
The first tab data is copied and pasted from in MYOB report. This report is basically the aged receivables of the company line by line.
The programming I need done is as follows:
1. When the client clicks on the green button a separate tab is created for each salesperson with their customers and the unpaid invoices shown as per my example .
2. If there is no salesperson's name they should all go into the last tab called errors
3. Once the client has reviewed the information they will press the red button and each tab will be e-mailed to the salesperson. We will need to look up the salespersons e-mail address from the e-mail look up tab