Image 01: http://s27.postimg.org/w449qsq83/image_01.jpg
Image 02: http://s24.postimg.org/ydlte90md/image_02.jpg
I'm a tennis coach at a high school so keeping track of records is one of my seasonal tasks. I made up a sample of what my record book looks typically looks like. If you take a look at image 01, I have the school that was played, name of my player, the position they played, the match score, and if they won or lost. I would like to take this data, which shows a team record , and have it split up into individual player records (image 02) instead of having to type out the information twice. So as I fill in the the team records, it will automatically fill in the boxes on another sheets for each player. Is there an easy way to do this? If you have a YouTube video or know of something on this forum that already has a similar problem solved by all means please send it my way instead of typing it out. I pretty good knowledge of Excel, but this is something I have not been able to figure out. Thank you.
Bookmarks