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