We continue our series on using Excel and VBA to automate your spreadsheets and develop powerful and sophisticated business tools in Excel. If you regularly use spreadsheets to produce a series of monthly charts and reports, or send spreadsheets to managers as part of a salary or incentive process, or use spreadsheets to track sales commissions, you can have VBA do the same task for you in a matter of seconds.
We use the specific example of a Salary Planning Tool to show how you can use VBA code to automate many time-intensive processes.
In Part I, we showed how Excel and VBA can be part of an HRIS strategy that uses the core HRIS for what it does well, and Excel and VBA to give you all the ‘good stuff’ you need to be an effective business partner.
Part 2 focused on using GUIs to develop a flawless and foolproof workflow, using ‘Userforms’ in VBA to display information and allow you to input data.
It would be helpful to review these presentations prior to viewing Part 3.