Sir Phoenix
10-17-2005, 08:10 PM
Alright... what I've made so far has been with the copious assistance of the members of this forum. So I share it with you all, and if you want to take all or part of it, feel free. There are two userforms on the final pages. One will allow you to create/change/delete employees for 3 different shifts. The other will allow you to make schedules for all 7 days of the week for different shifts.
Now... I need help with the next part, it's going to be a doozy. I want an area where people type how many months to schedule (max months is month(now())-December of next year)... then push a button. The button will make a new tab for each month (that isn't already created), tab named for the month and year. Then, for each week in the month, it lists all people, and gives them one schedule based on their personal shift, (evening workers get evening shifts, daytime get daytime). the next week, the shifts rotate. Keep repeating for all weeks through all months that was selected.
I don't even know where to begin for this... so... anyone interested in working with me on it? Reply here, or... hit me on aim 'phnx88'.
Thanks for any/all takers!
Now... I need help with the next part, it's going to be a doozy. I want an area where people type how many months to schedule (max months is month(now())-December of next year)... then push a button. The button will make a new tab for each month (that isn't already created), tab named for the month and year. Then, for each week in the month, it lists all people, and gives them one schedule based on their personal shift, (evening workers get evening shifts, daytime get daytime). the next week, the shifts rotate. Keep repeating for all weeks through all months that was selected.
I don't even know where to begin for this... so... anyone interested in working with me on it? Reply here, or... hit me on aim 'phnx88'.
Thanks for any/all takers!