Hi
We prepare a rota where volunteers assist with activities at Church, we normally just give out the rota (an excel sheet), but a number of people volunteer for more than one thing.
What I would like to do is to to give them a printed list showing in chronological order the activity they are assigned to. (thinking if I can achieve a listing, I can do a mail merge from excel into word so that I can include some additional text.
The mail merge part I am fine with.
I am struggling with how to take the table below, and transform it to the example I have called output below, it will obviously need to repeat moving on the next volunteer in the table.
Assuming Headings is Row 1 with columns A through to G
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>[TABLE="width: 636"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Would any one be able to help me out on this as I am stumped on where to start.
Many thanks [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
We prepare a rota where volunteers assist with activities at Church, we normally just give out the rota (an excel sheet), but a number of people volunteer for more than one thing.
What I would like to do is to to give them a printed list showing in chronological order the activity they are assigned to. (thinking if I can achieve a listing, I can do a mail merge from excel into word so that I can include some additional text.
The mail merge part I am fine with.
I am struggling with how to take the table below, and transform it to the example I have called output below, it will obviously need to repeat moving on the next volunteer in the table.
Assuming Headings is Row 1 with columns A through to G
Date | Deacon | Vestibule | Church am | Front door | Projection Sunday | Car Park |
07-Jan | M Bond | V Bond | R Pedro | G Pedro | R Townsend | S Everton |
14-Jan | R Cole | B Bond | C Chaplin | J L-Rogers/J Patel | R Townsend | T Thompson |
21-Jan | N Smith | B&B Smith | M Roberts | L Musk | M Murray | S Musk |
28-Jan | A Hill | A Rogers | M Bond | N Thompson | M Murray | N Smith |
04-Feb | S Everton | B L-Rogers | J Harper | S Musk | K Townsend | W Brown |
11-Feb | M Bond | C Smith | H Thompson | T Thompson | R Townsend | L Musk |
18-Feb | R Cole | M Gallagher | V Rogers | T Lamont | R Townsend | M Bond |
25-Feb | N Smith | A Bashar | R Matthews | T Matthews | M Murray | T Lamont |
Output | ||||||
Date | Name | Activity | ||||
07-Jan | M Bond | Deacon | ||||
28-Jan | M Bond | Church AM | ||||
11-Feb | M Bond | Deacon | ||||
18-Feb | M Bond | Car Park |
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Would any one be able to help me out on this as I am stumped on where to start.
Many thanks [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]