Excel VBA code development
Budget: $30 – $250 AUD
Modification of ‘Business Plan template v02.xlsm’ provided to allow for the following functionality:
On changes to Column J in “Projects” worksheet and Column I in “Services” worksheet, the cell reference(s), time/date of change and user’s name are recorded in a VBA variable
On close of the workbook, all changes (saved into the above variable) are included and sent in an email to notify of all changes occurred with the variable cleared upon email being sent.
On changes to Column J in “Projects” worksheet and Column I in “Services” worksheet, the cell reference(s), time/date of change and user’s name are recorded in a VBA variable
On close of the workbook, all changes (saved into the above variable) are included and sent in an email to notify of all changes occurred with the variable cleared upon email being sent.