Cannot change part of an array when sorting

indyitguy

Honorable
Feb 7, 2013
22
0
10,560
0
I have a workbook I'm using to track a super bowl prop pool. 5 worksheets contain all of the data and one worksheet contains a leaderboard and a place to select the correct answers to the questions. I pull the leaderboard in by (=transpose(named range)). The leaderboard consists of 3 columns, name, total points, and tie breaker (total score of the SB). If I try to sort by total points I get a "Cannot change part of an array" error. Is there a way to sort that leaderboard? Preferably each time it's updated but a sort button will be fine too.
 

Entomber

Estimable
Apr 21, 2014
96
0
4,610
14
MS Access should be part of the Office suite, and it binds data points together so they can be sorted and searched. You can then link the Access database to an Excel spreadsheet if you so wish...
 

indyitguy

Honorable
Feb 7, 2013
22
0
10,560
0
Yea I know Access is in the Office Suite and I really need to start getting into it when I go this deep into excel... lol I already have this setup and ready to go, all it needs to do is sort the leaderboard.
 

Entomber

Estimable
Apr 21, 2014
96
0
4,610
14
You can export data from Excel to Access, what I'm saying is I'm not sure if what you're describing can be done in Excel, while I know it can be done in Access.
 

indyitguy

Honorable
Feb 7, 2013
22
0
10,560
0
Gotcha... So what would be the best way to get started on getting everything moved to Access? It's really not that much data, People that are playing, their picks (30 questions), and their Tie Breaker pick (total score of the SB).
 

Entomber

Estimable
Apr 21, 2014
96
0
4,610
14
I don't have Access 2007, but you should be able to open a new blank database in Access, and import the data straight from an Excel file. Make sure you set the key in the master database to the player's name so that all of the other fields are then bound by the player name.
 
Thread starter Similar threads Forum Replies Date
M Apps General Discussion 1
R Apps General Discussion 2
Aksheev Apps General Discussion 4
L Apps General Discussion 2
F Apps General Discussion 6
M Apps General Discussion 1
U Apps General Discussion 1
F Apps General Discussion 3
M Apps General Discussion 4
C Apps General Discussion 2
B Apps General Discussion 8
Z Apps General Discussion 10
RepoDraghon Apps General Discussion 1
Z Apps General Discussion 3
A Apps General Discussion 3
B Apps General Discussion 1
J Apps General Discussion 4
D Apps General Discussion 1
D Apps General Discussion 3
J Apps General Discussion 6

ASK THE COMMUNITY