schedules with automatic updates
Hello, I have a schedule for different people, that work in different locations and on different days. I want to be able to extract each individual person and create a worksheet with their indivi...
ABNelson961 Yes, it's possible, but the solution will depend on the layout of your current worksheet, and possibly on how many people you schedule for a location.
The attached workbook shows a couple possibilities. With the Layout1 worksheet, the worksheets for each employee would have the same structure as the main worksheet, and – in its simplest form – would include a formula for nearly every cell (but the same formulas would apply to every employee's worksheet).
With the Layout2 worksheet, worksheets for each employee need include only a single formula (using Excel's built-in FILTER function). In both cases, a particular cell in the worksheet (I used A1) must contain the employee's name (or unique identifier).
