Custom Excel Schedule Workbook
Budget: $30 – $250 USD
I’m looking for an Excel specialist who can build a user-friendly scheduling workbook in Excel for Microsoft 365. The goal is to plan a 6-day workweek for roughly 25 employees across three offices while capturing who is on duty, where, and what they will be doing.
Workbook structure
• One worksheet for each day (Mon–Sat).
• Within every day sheet, clearly separated areas for Office 1, Office 2, and Office 3, each split into Morning and Afternoon and further broken down by department (Front Desk, Techs, Billing, Optical, Other).
• A master “Employees” sheet where staff names can be added or removed easily.
• A “Shift Duties” sheet listing duties grouped By type of task (my chosen categorization) that I can edit at any time.
• A read-only “Consolidated View” that automatically compiles all entries into a single week calendar for quick printing or review.
Data-entry requirements
1. Drop-down list for Employee Name fed from the Employees sheet.
2. Manual Start Time and End Time fields.
3. A multi-pick list for Shift Duties so multiple tasks can be assigned in one cell—this piece is essential. The list must update itself whenever I add or remove duties on the Shift Duties sheet.
Technical expectations
• Use dynamic named ranges or Excel tables so new employees or duties appear in the drop-downs instantly.
• Implement the multi-pick list with VBA or another reliable method that works smoothly in Microsoft 365 desktop.
• Keep formulas, conditional formatting, and any code well-commented so I can tweak them later if needed.
• Ensure the Consolidated View refreshes automatically as daily sheets are updated—no manual copying.
Deliverable
A fully functioning, moderately documented workbook that I can open and start scheduling with right away, plus any supporting VBA modules.
Also, does she needs to be password in a way that prevents inadvertent corrupting of its functionality
Workbook structure
• One worksheet for each day (Mon–Sat).
• Within every day sheet, clearly separated areas for Office 1, Office 2, and Office 3, each split into Morning and Afternoon and further broken down by department (Front Desk, Techs, Billing, Optical, Other).
• A master “Employees” sheet where staff names can be added or removed easily.
• A “Shift Duties” sheet listing duties grouped By type of task (my chosen categorization) that I can edit at any time.
• A read-only “Consolidated View” that automatically compiles all entries into a single week calendar for quick printing or review.
Data-entry requirements
1. Drop-down list for Employee Name fed from the Employees sheet.
2. Manual Start Time and End Time fields.
3. A multi-pick list for Shift Duties so multiple tasks can be assigned in one cell—this piece is essential. The list must update itself whenever I add or remove duties on the Shift Duties sheet.
Technical expectations
• Use dynamic named ranges or Excel tables so new employees or duties appear in the drop-downs instantly.
• Implement the multi-pick list with VBA or another reliable method that works smoothly in Microsoft 365 desktop.
• Keep formulas, conditional formatting, and any code well-commented so I can tweak them later if needed.
• Ensure the Consolidated View refreshes automatically as daily sheets are updated—no manual copying.
Deliverable
A fully functioning, moderately documented workbook that I can open and start scheduling with right away, plus any supporting VBA modules.
Also, does she needs to be password in a way that prevents inadvertent corrupting of its functionality