AndyDuncombe
New member
- Joined
- May 4, 2016
- Messages
- 29
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 365
So I run membership for a hockey club and we have over 1000 members.
It's important that the U18 members are put into the correct age grade teams - but even more important to know who has paid their dues and who hasn't.
I have created a workbook with multiple sheets - one sheet for every age group team.
EVERY member is listed on one sheet and I use conditional formatting to identify those who have paid, are pending or or have yet to pay their subscription.
i then manually copy and paste from the ALL sheet to the respective age group, 7, 8, 9 etc.
What I need is for one of you magicians to help me to automatically migrate from the ALL sheet to the relevant age team sheet!
I'm thinking create a data table on the ALL sheet and then use INDEX and MATCH to 'pull' the data?
If I fill column A with "7" on the (team)7 tab I want it to pull all the members with a 7 in column A on sheet ALL, then repeat this for every age group.
I can only just spell pivot table let alone create/use one!
The workbook is attached.
It's important that the U18 members are put into the correct age grade teams - but even more important to know who has paid their dues and who hasn't.
I have created a workbook with multiple sheets - one sheet for every age group team.
EVERY member is listed on one sheet and I use conditional formatting to identify those who have paid, are pending or or have yet to pay their subscription.
i then manually copy and paste from the ALL sheet to the respective age group, 7, 8, 9 etc.
What I need is for one of you magicians to help me to automatically migrate from the ALL sheet to the relevant age team sheet!
I'm thinking create a data table on the ALL sheet and then use INDEX and MATCH to 'pull' the data?
If I fill column A with "7" on the (team)7 tab I want it to pull all the members with a 7 in column A on sheet ALL, then repeat this for every age group.
I can only just spell pivot table let alone create/use one!
The workbook is attached.