divster27
New Member
- Joined
- Jan 19, 2021
- Messages
- 32
- Office Version
- 2016
- Platform
- Windows
I've got what i think should be a simple request... probably a little bit of VB
I've been tasked with producing a spreadsheet that shows all the remaining fixtures in the football season - serious stuff this - and i'd like the 'League Table' to update as users enter their predictions.
So when someone enters a prediction against the fixture (next to the H or A) - the total points on the far right hand side will update. that's easy enough
I'd like the Team Position in the table to move in line with their total points.
So from the paste below, if i was to put a 3 next to the Watford A fixture, the total will update to 48 in the league table, and Arsenal would move up to position 4
I know sorting is a manual task, but can it easily be automated?
I've been tasked with producing a spreadsheet that shows all the remaining fixtures in the football season - serious stuff this - and i'd like the 'League Table' to update as users enter their predictions.
So when someone enters a prediction against the fixture (next to the H or A) - the total points on the far right hand side will update. that's easy enough
I'd like the Team Position in the table to move in line with their total points.
So from the paste below, if i was to put a 3 next to the Watford A fixture, the total will update to 48 in the league table, and Arsenal would move up to position 4
I know sorting is a manual task, but can it easily be automated?
Arsenal | 45 | Wolves | 46 | Spurs | 39 | United | 46 | Chelsea | 50 | West Ham | 42 | ||||||||||
position | Team | Points | |||||||||||||||||||
Watford | A | Watford | H | Brighton | A | Watford | H | Arsenal | H | Wolves | H | 3 | Chelsea | 50 | |||||||
Leicester | H | Arsenal | A | Arsenal | H | Man City | A | Leicester | H | Liverpool | A | 4 | United | 46 | |||||||
Liverpool | H | West Ham | A | Leeds | A | Spurs | H | Burnley | A | Aston Villa | H | 5 | Wolves | 46 | |||||||
Aston Villa | A | Crystal Palace | H | Everton | H | Liverpool | A | Newcastle | H | Spurs | A | 6 | Arsenal | 45 | |||||||
Crystal Palace | A | Everton | A | Man Utd | A | Leicester | H | Norwich | A | Everton | H | 7 | West Ham | 42 | |||||||
Brighton | H | Leeds | H | West Ham | H | Everton | A | Brentford | H | Brentford | A | 8 | Spurs | 39 | |||||||
Southampton | A | Aston Villa | H | Newcastle | H | Norwich | H | Southampton | A | Burnley | H | ||||||||||
Manchester United | H | Newcastle | A | Aston Villa | A | Arsenal | A | Leeds | A | Chelsea | A | ||||||||||
West Ham United | A | Man City | H | Brighton | H | Brentford | H | West Ham | H | Arsenal | H | ||||||||||
Leeds | H | Burnley | A | Brentford | A | Brighton | A | Everton | A | Norwich | A | ||||||||||
Newcastle United | A | Brighton | H | Leicester | H | Chelsea | H | Wolves | H | Man City | H | ||||||||||
Everton | H | Chelsea | A | Liverpool | A | Crystal Palace | A | Man Utd | A | Brighton | A | ||||||||||
Tottenham Hotspur | A | Norwich | H | Burnley | H | Watford | H | ||||||||||||||
Chelsea | A | Liverpool | A | Norwich | A | ||||||||||||||||