Microsoft Excel Macro Process
Budget: £10 – £50 GBP
We have an excel file given to us which produces a series of PDF invoices (via macro process). We are unable to get it to work and require someone to look at the code and fix the problem.
The excel file pulls data from another excel file and then creates the PDF invoices. The process is as follows:
1 Open the file named ‘Monthly Billing Process.xlsm’
2 In cell D7, select the month to be billed using the arrow drop head to select the correct month.
3 Click the button labelled ‘Create Invoices’
4 To review all invoices created by the above process, click the button labelled ‘Review Invoicing’
Here are the attached files:
The excel file pulls data from another excel file and then creates the PDF invoices. The process is as follows:
1 Open the file named ‘Monthly Billing Process.xlsm’
2 In cell D7, select the month to be billed using the arrow drop head to select the correct month.
3 Click the button labelled ‘Create Invoices’
4 To review all invoices created by the above process, click the button labelled ‘Review Invoicing’
Here are the attached files: