Struggling to reset your staff roster every week? This step‑by‑step Excel macro tutorial will help. Record a macro, highlight your roster range (for example F6:AG49), press DEL to clear the contents, then stop recording. Insert a form‑control button, assign the macro, rename it (e.g., “Clear Record”) and watch it wipe last week’s schedule instantly! Use this trick with our excel roster template to plan 4‑week rotating shifts, customise shift codes, track headcount and FTE, highlight weekends and

Excel Macro Class 1 - Getting Started Programming Macros