Hi Alan i am new on the site, and i am having a lot of problems posting, i wonder if you could help me. This is what i am doing: Working on a staff weekly schedule, but i am completly stuck. i want to be able to fill the first part of the rosta (with everyone´s working hours for the different days of the week) and once i enter the range of hours they should work, i want to automatically fill the sheets for each day of the week. Lets say: person A works 9-17 on Monday, so i want to have all respective cells with vallue 1 on Monday Sheet. I would love to send the workbook as i am sure this explanation is only good to confuse you more, surrely it is with me. If you want to have a look at the workbook, and you know a way of sending it let me know. Thank ou for any comments/help. If none thank you the same we all have busy lifes.