Hey. thank you for looking into this...
In the top grid the days run from top to bottom. On the other grid it goes from left to right. On monday i got persons 4,6,9,12,14 and 18 on either morn or o-c. (open/close). On the grid below i use from that person 6,12,18. On tuesday top grid morning people are person 5,7,8,10,11,14,19 from them i use person 8,10,19 at the botom grid. Etc. The names i allready got in the grid at the bottom im try to duplicate as little as posible. For example person 6 work morn on monday and thursday. I only put person 6 on monday at the bottom grid not at thursday again. Person 12 work morn on monday and wednesday again only put him on for monday only. Person 10 tuesday and thursday morn again only usd on the bottom grid with tuesday only. Regards phillip On 5/31/09, Dave Bonallack <davebonall...@hotmail.com> wrote: > > Hi Phillip, > Not quite sure about the following: > "only if person 4 is working morning on monday 18 may then his name > can be added to the grid below" > > Only persons 4, 6, 9, 12, 14, 18 are working morning on monday 18. > Does this mean that they are the only ones that can go on the roster? > Your sample roster has other persons. > > Regards - Dave. > > > > From: pswa...@gmail.com > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ how to scamble names on work roster > Date: Sun, 31 May 2009 15:01:42 +0200 > > > > > > > > > > > Hi all.. > > I got this roster on a excell work > book. Could you please help me to get > the following. > > the names > on the first collumn has to be put random in the grid below the > > roster. but first check and see if > 1. the person work morn > shift. only if person 4 is working morning on monday 18 may then his name > can be added to the grid below > 2. every week i print one of these > rosters. these names must be scrambled every week on the below > grid. > 3. the last condition is that the names must be duplicated as > little as possible > > > From time to time i add or take away > names. > > > I include the sample file... > > > regards > > > Phillip > excell 2007 > windows xp > > > > > > > _________________________________________________________________ > Looking to change your car this year? Find car news, reviews and more > http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT > > > -- This email has been forwarded using a mobile phone with a internet/wap application. Go to www.operamini.com for more info --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
