OK, thanks for the response but I've probably not explained the problem well enough, the needs of the people we support vary from day to day and can change month by month, I have am excel spreadsheet that tracks these changes and it produces the day to day data represented in the sheet I uploaded, however that example is only one days data. The problem is that I need to generate rostas from this data quickly and covering a 4 week period...each day being different.