Forum Discussion
schedules with automatic updates
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).
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).
I must tell you thank you very much. At first I was having a problem configuring the formula, but it finally worked. I appreciate it very much. thank you (10x).
