fantasy basketball optimization problem

[splashz]

I want to play a fantasy basketball game where I need to build a team consisting of a certain number of players at each position. I also need to stay under a salary cap. The salary cap is in place to prevent people from just picking all the best players. I've attached a spreadsheet of players separated out by position. Each tab has player name, salary, and expected points. I want to find the optimal combination of PG, PG, SG, SG, SF, SF, PF, PF, C that stays under the salary cap and produces the highest expected points. Is this possible with macros or would I have to explore options outside of excel? Can someone point me in the right direction?