I'm trying to set up a spreadsheet where you should mark children's need of daycare for the summer.
Besides name do I need information of age group (below 3 year, above 3, or preschooler), what unit they belong to and a field with extra information.
I also would need the same information for the staff.
I do not know on beforehand how many children there will be.
That information would I like to have presented on separate sheets for every week. That sheet should be sorted on age group, preferably (but not necessary) with unit as sub argument to sort with. And this for both children and staff.
I hope I have been able to explain clear enough for you to get the picture. I have enclosed two picture, the raw data sheet, and one week.
I'm working on Excel 2013.
Thanks on beforehand!
Bookmarks