Excel Roster Maker with Macros
Budget: $30 – $250 AUD
I'm looking for an advanced Excel expert who can create a roster maker for me. This should be an Excel sheet that leverages automation with macros to help manage and create rosters for multiple shifts per day.
Key Features:
- Handling of multiple shifts per day: The roster maker should be able to accommodate AM, PM, and ND (night) shifts.
- User Inputs: The sheet will need to take in employee names and IDs, shift totals, and contracted hours.
- Complexity: This isn't a simple roster maker. It will need to use a range of formulas and conditional formatting, along with the automation through macros.
Ideal Skills:
- Expertise in Excel and VBA for Macros
- Experience with creating complex scheduling tools
- Ability to understand and implement conditional formatting and formulas
The goal is to have a functional, user-friendly Excel sheet that can simplify the task of roster creation. Please provide examples of similar projects you have completed in your proposal.
Key Features:
- Handling of multiple shifts per day: The roster maker should be able to accommodate AM, PM, and ND (night) shifts.
- User Inputs: The sheet will need to take in employee names and IDs, shift totals, and contracted hours.
- Complexity: This isn't a simple roster maker. It will need to use a range of formulas and conditional formatting, along with the automation through macros.
Ideal Skills:
- Expertise in Excel and VBA for Macros
- Experience with creating complex scheduling tools
- Ability to understand and implement conditional formatting and formulas
The goal is to have a functional, user-friendly Excel sheet that can simplify the task of roster creation. Please provide examples of similar projects you have completed in your proposal.