Kristy Cathro
New Member
- Joined
- Feb 25, 2016
- Messages
- 5
Hi,
Apologies for the long title - I am a complete novice and have no idea what the correct terminology is that I need to use.
I have a database of rugby players who have registered at our rugby club. They get graded into specific grades. Rather the filtering the "grades column" and copying & pasting their data into a separate worksheet, I would like to filter out all the grades individually into their own worksheets, so when I add/edit/remove player's details on the main database worksheet, it will automatically be updated in the individual grade worksheets.
The below table is a watered down version of the real database. The actual database consists of columns A-AW and rows 1-280 (not too sure if this information is relevant or not)
Database Worksheet:
<tbody>
</tbody>
Thanks
Kristy
Apologies for the long title - I am a complete novice and have no idea what the correct terminology is that I need to use.
I have a database of rugby players who have registered at our rugby club. They get graded into specific grades. Rather the filtering the "grades column" and copying & pasting their data into a separate worksheet, I would like to filter out all the grades individually into their own worksheets, so when I add/edit/remove player's details on the main database worksheet, it will automatically be updated in the individual grade worksheets.
The below table is a watered down version of the real database. The actual database consists of columns A-AW and rows 1-280 (not too sure if this information is relevant or not)
Database Worksheet:
First Name | Last Name | DOB | Weight | Grade | Comment |
John | Smith | 12/02/2003 | 45 | J2 | In coach A's team please |
Ben | Tucker | 23/07/2006 | 32 | J4 | Same team as Peter Parker |
Jason | Robertson | 06/06/2009 | 14 | J8 | NA |
Adrian | Adams | 30/01/2010 | 19 | J7 | NA |
<tbody>
</tbody>
Thanks
Kristy