I need a macro that will take values at random from a list of values an
get them to add up to an exact quantity, constraints being that eac
value that it uses must be from the original list, and each value ca
be used only once.

Right now I have it set up to split the values into two lists and the
move individual values from one list to the other until one reaches th
desired quantity - problem with this is that it takes too long an
sometimes can't find a solution (there is ALWAYS a solution).

Any ideas

--
goos
-----------------------------------------------------------------------
goose's Profile: http://www.excelforum.com/member.php...fo&userid=3053
View this thread: http://www.excelforum.com/showthread.php?threadid=54977