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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---