bugssy
Cricketer Of The Year
doing player of the year for wcc
using excel and i need to ask a question so hopefully you guys can help.
ok i have 3 div and 10 teams in div 1, 8 teams in div 2 and 6 teams in div 3. i have all 24 teams down on seperate sheets within the excel spread sheet. so i have all ten teams then i have all the players from those tean teams on one additional page. with in the ten team pages there will be 3,2,1 points given out to the players of the games etc, and over 18 rounds the player with the most points wins etc. so the team pages are fine all sums done and worked out however how do i link the team pages to the overall divisional page so it then sorts out all the points given through out the season to give me the overall winner so i dont have to sit there and go through adding them up on different pages. ( i know it can be done as i have seen it done before but i just not sure how to link it)
Your help will be muchly appreciated.
using excel and i need to ask a question so hopefully you guys can help.
ok i have 3 div and 10 teams in div 1, 8 teams in div 2 and 6 teams in div 3. i have all 24 teams down on seperate sheets within the excel spread sheet. so i have all ten teams then i have all the players from those tean teams on one additional page. with in the ten team pages there will be 3,2,1 points given out to the players of the games etc, and over 18 rounds the player with the most points wins etc. so the team pages are fine all sums done and worked out however how do i link the team pages to the overall divisional page so it then sorts out all the points given through out the season to give me the overall winner so i dont have to sit there and go through adding them up on different pages. ( i know it can be done as i have seen it done before but i just not sure how to link it)
Your help will be muchly appreciated.