Hi All
I am going to try and explain this a best I can. I am trying to create a spreadsheet for my football league.
On one sheet I have a table of all the teams in the league and then individual tables for each teams showing the players.
On another sheet I want to enter the results from the fixtures using drop down boxes (I know how to do this part) what I then want it to do is say if the score was "2 - 1" I want it to recognize the team playing and then open/create boxes below the fixtures to enter the people who scored.
Can this be done so it recognizes the numbers I enter in the scoresheet part so the max number of boxes appear to enter the scorers for each team?
Thanks in advance and sorry for the head boggle.
TP
I am going to try and explain this a best I can. I am trying to create a spreadsheet for my football league.
On one sheet I have a table of all the teams in the league and then individual tables for each teams showing the players.
On another sheet I want to enter the results from the fixtures using drop down boxes (I know how to do this part) what I then want it to do is say if the score was "2 - 1" I want it to recognize the team playing and then open/create boxes below the fixtures to enter the people who scored.
Can this be done so it recognizes the numbers I enter in the scoresheet part so the max number of boxes appear to enter the scorers for each team?
Thanks in advance and sorry for the head boggle.
TP
