Hello all... I have been struggling building a automated schedule for my mother. She works at a hospital and there are 8 nurses on a rotating 14 week schedule. Starting in 2012; ending in 2015
-WHAT I HAVE COMPLETED-
1st - the monthly calendar changes dates and days depending on the year selected and month selected in two drop down boxes
2nd - I managed to compare each years holidays to the month selected the days will turn the cells a red is a stat holiday or yellow if its a weekend
-What I NEED-
1st - Now the the calendar is self populating I was looking for some sound logic to help populate the schedule for each person referencing the rotation number 1-14 and what day it is in Mon-Sun... each person would have a different shift depending on those variables.
does this make sense and is this at all do able
-WHAT I WAS THINKING-
in VBA compare the date to the holidays to ensure its not a weekend nor a stat holiday first
*IF cells(1,1) = range (10,10)
15,15) ' i dont know how to do ranges.
then nurse "A" gets the day off else
if cells(1,1) = "1-Jan" and "monday" then nurse A works a "Day"
etc etc etc...
do you think if then else is the way to create such a program or is there an easier way? I have taught myself and will work very hard to try any suggestions... I really wanna learn VBA. It will help with my job also.
Thanks for your time,
Kastsnow
if you need anymore info let me know!
-WHAT I HAVE COMPLETED-
1st - the monthly calendar changes dates and days depending on the year selected and month selected in two drop down boxes
2nd - I managed to compare each years holidays to the month selected the days will turn the cells a red is a stat holiday or yellow if its a weekend
-What I NEED-
1st - Now the the calendar is self populating I was looking for some sound logic to help populate the schedule for each person referencing the rotation number 1-14 and what day it is in Mon-Sun... each person would have a different shift depending on those variables.
does this make sense and is this at all do able
-WHAT I WAS THINKING-
in VBA compare the date to the holidays to ensure its not a weekend nor a stat holiday first
*IF cells(1,1) = range (10,10)
15,15) ' i dont know how to do ranges. then nurse "A" gets the day off else
if cells(1,1) = "1-Jan" and "monday" then nurse A works a "Day"
etc etc etc...
do you think if then else is the way to create such a program or is there an easier way? I have taught myself and will work very hard to try any suggestions... I really wanna learn VBA. It will help with my job also.
Thanks for your time,
Kastsnow
if you need anymore info let me know!
