Access 2007
I run an office football pool and one of the worksheets contains Division Standings. (Yeah, I just posted another question). There are 8 divisions, 8 players in each division, and the columns in each section are: Player, Wins, Losses, Ties, Pct, PF (points for), and PA (points against).
Each division has to be sorted on:
1. Pct (Largest to Smallest)
2. PF (Largest to Smallest)
3. PA (Smallest to Largest)
This requires me to select each division, open the sort dialog box, add 2 more levels, select Pct, PF, and PA in each of the levels, then select the appropriate Order.
Does anyone have a suggestion as to a solution so I don't spend 5-10 minutes going through the steps?
I would prefer to NOT use macros, because of the security issues that go along with enabling macros.
I do know VBA, so, if that's a solution I could create some code. I have used VBA in Access, not Excel, but have exported from Access to Excel, using VBA to format the cells, so I can perform Selects, but haven't performed Sorts in VBA.
I run an office football pool and one of the worksheets contains Division Standings. (Yeah, I just posted another question). There are 8 divisions, 8 players in each division, and the columns in each section are: Player, Wins, Losses, Ties, Pct, PF (points for), and PA (points against).
Each division has to be sorted on:
1. Pct (Largest to Smallest)
2. PF (Largest to Smallest)
3. PA (Smallest to Largest)
This requires me to select each division, open the sort dialog box, add 2 more levels, select Pct, PF, and PA in each of the levels, then select the appropriate Order.
Does anyone have a suggestion as to a solution so I don't spend 5-10 minutes going through the steps?
I would prefer to NOT use macros, because of the security issues that go along with enabling macros.
I do know VBA, so, if that's a solution I could create some code. I have used VBA in Access, not Excel, but have exported from Access to Excel, using VBA to format the cells, so I can perform Selects, but haven't performed Sorts in VBA.
