That sounds like a nice problem for the solver add-in.  all linear
constraints.  That will tell you if its possible or not.  I dont think
a macro is needed?

On Jun 24, 11:51 am, Abdul Rehman <stevejamesrica...@gmail.com> wrote:
> Hi All,
>
> Is it possible to program a excel sheet to schedule 4 call center agents
> working in 3 different shift(0630-1430, 1430-2230 and 2230-0630) for 6 days
> in a week( 4 days for call center operations and for 2 days for other
> works) and getting single day off on different days...
> What I want to ask is to possible to put inmacros tht will calculate the
> execute staff schedulling based on the above prarmeters????
>
> --
> Warm Regards,
> Abdul Rehman.
>
> "Woods are lovely, dark and deep
> But I have promises to keep,
> And miles, miles and miles to go before I sleep."

--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to