christ_is_the_one
New Member
- Joined
- Jan 26, 2005
- Messages
- 8
I have a excell workbook containing multiple sheets for a church camp roster. On sheet is the master list and the others are a list for each church (the other sheets don't have names they just count the ones from the master sheet and return a number).
I want to a few other sheets that take the roster and divide it into classes based on age. One sheet will be for 0-2 year olds and will contain only their names, the next will be for 3-4 yr olds and will contain only their names, etc.
I want these sheets to automatically take the info from the master roster sheet as it changes (as we add new people or take off people) based on these criteria.
The master sheet contains their names, ages, and various other info. I want to be able to take all of this info and put it on these new sheets as I explained above.
Any help is appreciated. Thanks.
Sims
I want to a few other sheets that take the roster and divide it into classes based on age. One sheet will be for 0-2 year olds and will contain only their names, the next will be for 3-4 yr olds and will contain only their names, etc.
I want these sheets to automatically take the info from the master roster sheet as it changes (as we add new people or take off people) based on these criteria.
The master sheet contains their names, ages, and various other info. I want to be able to take all of this info and put it on these new sheets as I explained above.
Any help is appreciated. Thanks.
Sims