Help to START. Need big time help/advice on how to go ahead with the Scheduling using Excel:

[pedie]

I am trying to build a scheduler [which is a big time headache] but just dont know how to build one - I have thought over it again and again but just dont know how this can be taken care of.
It could be really easy though but need a start....

i HAVE uploaded my sample file on web [Link] <<< here.


0. The shift will be rotational for everyone [no repitations...except the only when the critiria mentioned in requirement cant be met..]
1. I want vba to look at the date range which is start and end date and make schedule [in shift wise] till end date.

2. Conditions: if User 1 is doing "shift 1" in previous month/last schedule then assign next shift for this month which is "shift 2" else assign shift 1 by default.

3. What i really want to achieve here is to divide 70 or more users/employees divided for each week schedule meeting critiria mentioned in red font areas with shift type and requirement per shift....

Please ask any question if i dont make sense....because i myself 'm consufused how to achieve this...
Manually it take so much time and also creates error...
So please kindly help.


Thank you soo much.

<TABLE style="WIDTH: 170pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=226><COLGROUP><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #c2d69a; WIDTH: 170pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: black 2pt double; mso-ignore: colspan" class=xl90 height=17 width=226 colSpan=3>REAPEAT GENERATED SHIFT FOR …..?</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #c2d69a; HEIGHT: 12pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl74 height=16>WEEKS</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c2d69a; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl96>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c2d69a; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 2pt double" class=xl97>=>1 MONTH</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #c2d69a; HEIGHT: 11.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl75 height=15></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c2d69a; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl76></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c2d69a; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl77></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 2pt double; mso-ignore: colspan" class=xl93 height=15 colSpan=3>REQ. AS PER DATE RANGE PROVIDED:</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>START</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl68>3/22/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 2pt double" class=xl69>DAYS</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>END</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl68>4/6/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>15</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl66 height=15>TYPE</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl64>SHIFT</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl65>EMP REQ:</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl70>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 2pt double" class=xl69>4</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>7</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>9</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>14</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>17</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>5</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>5</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>5</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>4</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=15>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>70</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl73>70</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl87 height=15 colSpan=2>REGION COUNT / USER</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl89></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>A</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl81>30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 2pt double" class=xl82></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>B</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>40</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl83 height=15></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl78></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl79></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl87 height=15 colSpan=2>EMP REPT. TO/ R. MANAGER</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl89></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl81>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 2pt double" class=xl82>A</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>A</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>A</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>B</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>B</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>B</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>B</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 12pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl84 height=16>TOTAL EMP.</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl85>70</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl86>~A~ = 30, ~B~ = 40</TD></TR></TBODY></TABLE>

 

[John Davis]

I am trying to build a scheduler [which is a big time headache] but just dont know how to build one - I have thought over it again and again but just dont know how this can be taken care of.
It could be really easy though but need a start....

i HAVE uploaded my sample file on web [Link] <<< here.


0. The shift will be rotational for everyone [no repitations...except the only when the critiria mentioned in requirement cant be met..]
1. I want vba to look at the date range which is start and end date and make schedule [in shift wise] till end date.

2. Conditions: if User 1 is doing "shift 1" in previous month/last schedule then assign next shift for this month which is "shift 2" else assign shift 1 by default.

3. What i really want to achieve here is to divide 70 or more users/employees divided for each week schedule meeting critiria mentioned in red font areas with shift type and requirement per shift....

Please ask any question if i dont make sense....because i myself 'm consufused how to achieve this...
Manually it take so much time and also creates error...
So please kindly help.


Thank you soo much.

<TABLE style="WIDTH: 170pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=226><COLGROUP><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #c2d69a; WIDTH: 170pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 2pt double; BORDER-RIGHT: black 2pt double; mso-ignore: colspan" class=xl90 height=17 width=226 colSpan=3>REAPEAT GENERATED SHIFT FOR …..?</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #c2d69a; HEIGHT: 12pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl74 height=16>WEEKS</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c2d69a; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl96>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c2d69a; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 2pt double" class=xl97>=>1 MONTH</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #c2d69a; HEIGHT: 11.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl75 height=15></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c2d69a; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl76></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #c2d69a; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl77></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 2pt double; mso-ignore: colspan" class=xl93 height=15 colSpan=3>REQ. AS PER DATE RANGE PROVIDED:</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>START</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl68>3/22/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 2pt double" class=xl69>DAYS</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>END</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl68>4/6/2011</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>15</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl66 height=15>TYPE</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl64>SHIFT</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl65>EMP REQ:</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl70>1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 2pt double" class=xl69>4</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>7</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>9</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>14</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>17</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>5</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>5</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>5</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl67 height=15>SHIFT</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl70>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl69>4</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #0f253f; HEIGHT: 11.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=15>0</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>70</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #0f253f; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl73>70</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl87 height=15 colSpan=2>REGION COUNT / USER</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl89></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>A</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl81>30</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 2pt double" class=xl82></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>B</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>40</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl83 height=15></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl78></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl79></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0; mso-ignore: colspan" class=xl87 height=15 colSpan=2>EMP REPT. TO/ R. MANAGER</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl89></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #f0f0f0" class=xl81>9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 2pt double" class=xl82>A</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>11</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>A</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>A</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>B</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>B</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 6</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>B</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 11.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl80 height=15>R MNG 7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: #f0f0f0" class=xl81>10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 2pt double" class=xl82>B</TD></TR><TR style="HEIGHT: 12pt" height=16><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: windowtext 2pt double; BACKGROUND-COLOR: #d99795; HEIGHT: 12pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl84 height=16>TOTAL EMP.</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl85>70</TD><TD style="BORDER-BOTTOM: windowtext 2pt double; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #d99795; BORDER-TOP: #f0f0f0; BORDER-RIGHT: windowtext 2pt double" class=xl86>~A~ = 30, ~B~ = 40</TD></TR></TBODY></TABLE>

Would this be of any help?

http://www.wolfebyte.com/visual-basic-scheduler-pic.php

 

[pedie]

John, thanks for suggestion i could be very useful. Checking through it...
But i want the formula/vba to achieve/show me calculation how to achieve required staffing depending on different critirias..

Thanks again.

 

[pedie]

John, that was a good one...but unfortunately we are not to use any 3rd party software/tool we are to build one ourself so, could someone please suggest me how to go ahead about it?

Thank you soo much again.

 

[John Davis]

John, thanks for suggestion i could be very useful. Checking through it...
But i want the formula/vba to achieve/show me calculation how to achieve required staffing depending on different critirias..

Thanks again.

Pedie,

I've not had such a task in a long time. At that time I used Microsoft Projects to handle the requirement. Sorry, I could not be of more help.

 

[pedie]

Thats k John, i hope someone comes to recue...

By the way is there a way to unlock the exe file? they have mentioned in help file that I can unlock it for free and the password is given.

Incase if i dont need another software to unlock then... I might want to check how this thing is build...

 

[pedie]

bump!