item price sorting

thanks for help guys

i tried to add the solver but it came up with this error

[URL=http://i.imgur.com/vmOr8tY.jpg[/URL]

no files open, the solver.xlam is there

this is what i need

the list of available items on the left, i select how many i want of each, and as you see the max i can spend (7.80), what excell does is then sorts a list of items in a separate sheet/column showing the items and quantities and total value

http://i.imgur.com/pY7d0PE.jpg