How to use Solver with vba for required results

[amolryeolekar]

I want to use solver for getting folllowing results
I want to generate a list of id nos say 3-4 any id nos which is having total width is the ht of that equipment from master
criteria-
eq prog no age
ba1 1120 oldest age first

Constraints-1.Total ht of width should not be >4200 if ba1 (see master sheet) 2.Total wt of id nos should not be more than as wt mentioned in master say ba1 <=80mt

result should be the group of ids may 3 is or 4 depending upon the max ht and max wt can be accomodated in qe (say ba1) so that max wt and max ht can be filled in one eq,ie best combination of oldest id no with same program no with max. ht and max wt -

list of id nos from "data sheet" this may be not correct but solver can give best combinations list of id nos which can be process


see attachment