Take a good look at the Solver Add-in. It may take some work to setup, but
its very good at solving criteira based scenarios.

--
Best Regards,

Luke M
"Susan in Sacramento" wrote in
message ...
I need to configure pallets of varying sizes & weight into a container.
The
Containers are 53 by 8 feet long and can carry approximately 45,000 lbs.
Below is the pallets that need to be put into containers. I need
something
that will return the best breakdown of what to put in a container;
container
1, 2, 3 etc:

ITEM # Pallet Weight ea
270 4 1883
271 14 2038
404 6 2434
253 20 1040
286 2 2771
255 8 2267