JokelesComedian
Board Regular
- Joined
- Mar 26, 2012
- Messages
- 85
Hello,
I have Excel 2010 and I have a work schedule for the Army. I have it auto populate if a person is working or off based off a selectable variable. Select 5&2 and it will post 5 days working and 2 days off. The problem is we have to have a set number of people working every day so sometimes we are 3 people short for work and sometimes have too many. So far I have only functions and no VBA but I can using VBA is not a problem, I just don't know the coding that well.
The table looks something like this...
A1 B1 C1 D1 E1 F1 G1 H1
Johnson 2 3 4 5 X1 X2 1
The numbers show consecutive days of work and X1 is "day off 1". Each column is a day of the month and the amount of people working are added at the bottom. The amount of days the individual is added up at the end of the row.
Idealy I would like excel to balance the amount of people working and how often they work. If I say I need 20 people working every day then I would like the people that are off to be scheduled to work if need be based off the amount of days they haced worked for the month.
I dont know how to attach the document to this but I have one if need be. I dont think this can be done with excel formulas because of circular referances, but I am up for suggestions.
Thank you for your time and considerations,
Zach
I have Excel 2010 and I have a work schedule for the Army. I have it auto populate if a person is working or off based off a selectable variable. Select 5&2 and it will post 5 days working and 2 days off. The problem is we have to have a set number of people working every day so sometimes we are 3 people short for work and sometimes have too many. So far I have only functions and no VBA but I can using VBA is not a problem, I just don't know the coding that well.
The table looks something like this...
A1 B1 C1 D1 E1 F1 G1 H1
Johnson 2 3 4 5 X1 X2 1
The numbers show consecutive days of work and X1 is "day off 1". Each column is a day of the month and the amount of people working are added at the bottom. The amount of days the individual is added up at the end of the row.
Idealy I would like excel to balance the amount of people working and how often they work. If I say I need 20 people working every day then I would like the people that are off to be scheduled to work if need be based off the amount of days they haced worked for the month.
I dont know how to attach the document to this but I have one if need be. I dont think this can be done with excel formulas because of circular referances, but I am up for suggestions.
Thank you for your time and considerations,
Zach