VBA sample for max value pack creation
J, Deepak
1
Reputation point
Hi guys
I have a Set of tagged items 100+ and its unique code and value.
We need to create max no of pack with below condition
- one Pack should contain 20 items
- each pack should have one B type tag and 19 A type tags
- There value max sum need to be with in limits ( Specified in Excel )
- Each pack should have unique Items list, cannot use the same item in different packs
Please help..
Eg