Hi guys,
I am working on a project at the moment which requires information from 2 different sources to be consolidated into just one row with the title.
To give an example, I have two football teams, team 1 & 2 (because I'm feeling creative you see). If I am tracking their progress monthly and I end up with two tables, each with 3 fields, to track which teams they played and the goals scored, I would get something like the following:
<TBODY>
</TBODY>
If I then want to make a list to know how many goals the opposing teams (3-8) have conceded, regardless of who they were against, what would be the best way to do this automatically, preferably in VBA?
I need these to feed in to a different sheet to show how many goals each team have conceded, but I am struggling when 1 team has been played by both Teams 1 & 2.
I am hoping to end up with something like this, only automatic as the number of 'Teams' I am actually using is far far higher.
<TBODY>
</TBODY>
The actual project I am working on has nothing to do with football but it is the same basic thing I am trying to achieve, so if someone could help with this I will hopefully be able to apply the lessons learnt here to my own problem as a resolution.
Thanks in advance!
I am working on a project at the moment which requires information from 2 different sources to be consolidated into just one row with the title.
To give an example, I have two football teams, team 1 & 2 (because I'm feeling creative you see). If I am tracking their progress monthly and I end up with two tables, each with 3 fields, to track which teams they played and the goals scored, I would get something like the following:
Team 1</SPAN> | Team 2</SPAN> | |||
Team Played</SPAN> | Goals Scored</SPAN> | Team Played</SPAN> | Goals Scored</SPAN> | |
Team 3</SPAN> | 2</SPAN> | Team 3</SPAN> | 1</SPAN> | |
Team 4</SPAN> | 1</SPAN> | Team 7</SPAN> | 0</SPAN> | |
Team 5</SPAN> | 0</SPAN> | Team 8</SPAN> | 4</SPAN> | |
Team 6</SPAN> | 3</SPAN> | Team 4</SPAN> | 1</SPAN> |
<TBODY>
</TBODY>
If I then want to make a list to know how many goals the opposing teams (3-8) have conceded, regardless of who they were against, what would be the best way to do this automatically, preferably in VBA?
I need these to feed in to a different sheet to show how many goals each team have conceded, but I am struggling when 1 team has been played by both Teams 1 & 2.
I am hoping to end up with something like this, only automatic as the number of 'Teams' I am actually using is far far higher.
Team Name</SPAN> | Goals Conceded</SPAN> |
Team 3</SPAN> | 3</SPAN> |
Team 4</SPAN> | 2</SPAN> |
Team 5</SPAN> | 0</SPAN> |
Team 6</SPAN> | 3</SPAN> |
Team 7</SPAN> | 0</SPAN> |
Team 8</SPAN> | 4</SPAN> |
<TBODY>
</TBODY>
The actual project I am working on has nothing to do with football but it is the same basic thing I am trying to achieve, so if someone could help with this I will hopefully be able to apply the lessons learnt here to my own problem as a resolution.
Thanks in advance!