Hi,
I am trying to create a spreadsheet that can collect children’s ‘Golden time’ activity choices throughout 4 classes and then transfer these to ‘activity registers’ for the activity leaders.
The idea is that the Activity Leaders fill in the ‘Overview of Activities’ page (there can be up to a maximum of 30 activities, but not all will always be filled in) – this table is then copied to the class pages in the ‘Golden Time’ section (allowing each class to see the choices on offer and the number of spaces left).
So far, I have created drop down menus in Column D for Emerald, Ruby, Gold and Sapphire class (allowing each child’s choice to be entered easily and accurately).
I can create the spreadsheet and make it look the way I think would work best within school, but do not know how to collect all of the activity choices from the four classes and sort these into activity registers so that each leaders knows which children are coming to their activity (and also if they come from Em, Gold, Ruby or Sapphire.
Can this be done? Would it need a special VBA?
Any suggestions would be warmly welcomed.
Please see this workbook example file: https://www.box.com/s/f221d6cb86333e08efb9
Matt
I am trying to create a spreadsheet that can collect children’s ‘Golden time’ activity choices throughout 4 classes and then transfer these to ‘activity registers’ for the activity leaders.
The idea is that the Activity Leaders fill in the ‘Overview of Activities’ page (there can be up to a maximum of 30 activities, but not all will always be filled in) – this table is then copied to the class pages in the ‘Golden Time’ section (allowing each class to see the choices on offer and the number of spaces left).
So far, I have created drop down menus in Column D for Emerald, Ruby, Gold and Sapphire class (allowing each child’s choice to be entered easily and accurately).
I can create the spreadsheet and make it look the way I think would work best within school, but do not know how to collect all of the activity choices from the four classes and sort these into activity registers so that each leaders knows which children are coming to their activity (and also if they come from Em, Gold, Ruby or Sapphire.
Can this be done? Would it need a special VBA?
Any suggestions would be warmly welcomed.
Please see this workbook example file: https://www.box.com/s/f221d6cb86333e08efb9
Matt