Hi All
Hope someone can guide me in a direction here as i have no idea where to start. Basically my Scenario is that i have a Sheet with Variable number of "Rounds" on it, each "Round" contains variable number of teams and then 4 cells containing Scores(For, Against, Aggregate and Points)
What i am trying to achieve is to have a Data Entry form on another Sheet, where i can have a dropdown for Round and then Dropdown for Team, and then enter the scores and have a macro that will populate the entered data on the other sheet in the relevant Round and for the relevant Team
Hope this makes sense
Hope someone can guide me in a direction here as i have no idea where to start. Basically my Scenario is that i have a Sheet with Variable number of "Rounds" on it, each "Round" contains variable number of teams and then 4 cells containing Scores(For, Against, Aggregate and Points)
What i am trying to achieve is to have a Data Entry form on another Sheet, where i can have a dropdown for Round and then Dropdown for Team, and then enter the scores and have a macro that will populate the entered data on the other sheet in the relevant Round and for the relevant Team
Hope this makes sense
