question

JDeepak-2257 avatar image
0 Votes"
JDeepak-2257 asked

VBA sample for max value pack creation

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

  1. one Pack should contain 20 items

  2. each pack should have one B type tag and 19 A type tags

  3. There value max sum need to be with in limits ( Specified in Excel )

  4. Each pack should have unique Items list, cannot use the same item in different packs

Please help..


Eg


134343-image.png


office-vba-dev
image.png (204.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers