aussie_striker
New Member
- Joined
- Jul 22, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I have a workbook that a ladder and competition fixtures. What I am trying to do is get the next 3 rounds opposition to display on the Ladder sheet. I cannot think of anyway that I can do it using formulas so think vba is the better option. If you can think of a formula to do it I'm open to suggestions.
The excel2 image shows the ladder sheet and the result I am after noting that I have reduced the name down using a left command taking off the last 14 digits. I also added the current ladder position of the team using a index match lookup to the ladder. This would be the preferred format if achievable.
The excel1 image is the fixtures sheet. I'm thinking it will need to look up the row that matches the ladder sheet ie 4, 5, 6. as well as having the team corresponding to the one on the ladder. Then it has to determine if it is in column F or column H and return the opposite column result.
The loop would come into doing it for each team then for each round. I'm guessing a loop inside a loop to achieve it.
Hope that makes sense.
The excel2 image shows the ladder sheet and the result I am after noting that I have reduced the name down using a left command taking off the last 14 digits. I also added the current ladder position of the team using a index match lookup to the ladder. This would be the preferred format if achievable.
The excel1 image is the fixtures sheet. I'm thinking it will need to look up the row that matches the ladder sheet ie 4, 5, 6. as well as having the team corresponding to the one on the ladder. Then it has to determine if it is in column F or column H and return the opposite column result.
The loop would come into doing it for each team then for each round. I'm guessing a loop inside a loop to achieve it.
Hope that makes sense.