Mar 30 2022 11:16 AM
I am trying to make a 2023 calendar year Employee Staffing file. I want to be able to auto sort the names alphabetically, and also have the date headline each week without having to manually enter a date in cell A and drag across the row (53 times for each week!).
Here's an example of what it looks like now:
Sun | Mon | Tue | Wed | Thur | Fri | Sat | Week# |
1-Jan | 2-Jan | 3-Jan | 4-Jan | 5-Jan | 6-Jan | 7-Jan | |
Charlene | Dan | Charlene | Charlene | Charlene | Dan | Dave | 3 |
Dan | Eva | Dave | Dan | Dan | Dave | John M | |
Ian | Evan | Eva | Dave | Dave | Evan | Linn | |
Kim | Grace | Evan | Eva | Eva | Grace | Lori | |
Simone | Jennifer | Grace | Evan | Evan | Ian | Tim M | |
Jessica | Ian | Grace | Grace | Jessica | Xcinia | ||
John | Jennifer | Ian | Ian | John | |||
Julia | Jessica | Jessica | Jessica | Julia | |||
8-Jan | 9-Jan | 10-Jan | 11-Jan | 12-Jan | 13-Jan | 14-Jan | |
John M | Dan | Dave | Charlene | Charlene | Charlene | Charlene | 4 |
Linn | Dave | Eva | Dan | Dan | Dan | Eva | |
Lori | Eva | Evan | Dave | Dave | Dave | Grace | |
Tim M | Evan | Grace | Eva | Evan | Evan | Jennifer | |
Xcinia | Grace | Ian | Evan | Ian | Grace | Julia | |
Ian | Jennifer | Grace | Jessica | Ian | |||
Jennifer | Jessica | Jessica | John | Jessica | |||
pp | |||||||
15-Jan | 16-Jan | 17-Jan | 18-Jan | 19-Jan | 20-Jan | 21-Jan | |
Charlene | Dan | Dan | Charlene | Charlene | Charlene | Dave | 1 |
Eva | Eva | Dave | Dan | Dan | Dan | Evan | |
Grace | Evan | Eva | Dave | Dave | Dave | Jessica | |
Jennifer | Grace | Evan | Eva | Grace | Evan | Linn | |
Julia | Ian | Grace | Evan | Ian | Grace | Molly | |
Jennifer | Jennifer | Ian | Jessica | Ian | Stephanie | ||
Jessica | Jessica | John | John | Jessica | |||
John | Kim | Kim | Julia | John | |||
22-Jan | 23-Jan | 24-Jan | 25-Jan | 26-Jan | 27-Jan | 28-Jan | |
Evan | Dave | Dave | Charlene | Charlene | Charlene | Charlene | 2 |
Jessica | Eva | Eva | Dan | Dan | Dan | Dan | |
Linn | Evan | Grace | Dave | Dave | Dave | Ian | |
Molly | Grace | Ian | Eva | Eva | Evan | Kim | |
Stephanie | Ian | Jennifer | Evan | Evan | Grace | Simone | |
Jennifer | Julia | Grace | Grace | Ian | |||
Jessica | Kim | Jessica | Ian | John | |||
Julia | Linn | John | Jessica | Julia | |||
pp | |||||||
Mar 30 2022 12:12 PM
I think for anybody to help out here, we'd need a bit more data ("bit" may be understating it).
Organizing the data is one thing, but if you want Excel to "to the heavy lifting" it would help if you could identify where it has to go to do that lifting.
Mar 31 2022 12:17 PM