skinnea
Board Regular
- Joined
- Mar 15, 2003
- Messages
- 137
- Office Version
- 365
- Platform
- Windows
Hoping someone can help - I'm sure this is simple and I'm just dim!
I have a spreadsheet that records candidates (one per sheet) and the scores they achieve on 3 tests, each test consisting of multiple elements.
Each sheet will sum that candidates scores across the elements and give a total for each of the 3 tests.
On a summary sheet I want to show (in rows) the candidates' name, and the total score for each of the 3 tests. That's easy, i can just directly reference each of the cells on the individual sheets (eg =Sheet1!A1)
BUT I want to do two other slightly more complex things...
1 - I want to pull the sheet name into a cell and show that as part of the row for each candidate
2 - I'd love to automatically rank the candidates by putting the highest scorer at the top, lowest at the bottom etc
Does that start to go into the realms of VB...? Thanks in advance!
I have a spreadsheet that records candidates (one per sheet) and the scores they achieve on 3 tests, each test consisting of multiple elements.
Each sheet will sum that candidates scores across the elements and give a total for each of the 3 tests.
On a summary sheet I want to show (in rows) the candidates' name, and the total score for each of the 3 tests. That's easy, i can just directly reference each of the cells on the individual sheets (eg =Sheet1!A1)
BUT I want to do two other slightly more complex things...
1 - I want to pull the sheet name into a cell and show that as part of the row for each candidate
2 - I'd love to automatically rank the candidates by putting the highest scorer at the top, lowest at the bottom etc
Does that start to go into the realms of VB...? Thanks in advance!
Last edited: