Hi,

I have different items which needs to be packed in different bags based on the following criteria. I have an itemized spreadsheet with the weight of each item (attached in link). I am looking for a solution to get the items packed in bags, fulfilling the criteria as mentioned below. For that reason, I would like to get which bag can contain how many items

– packet of items to be randomly packed in each bag such a way that the total weight shall not exceed 2.5 kg.
– each bag shall have mix of items from each category with at least 2 category items in each bag.
– Bag numbers shall be sequentially assigned in column F based on the first number which is manually assigned. (in example the bag number starts with 4001),

To achieve the desired result can formula be used or VBA is required? Appreciate, any ideas /solution to get the desired result.

Thanks in advance. https://1drv.ms/x/c/5184dd66ded11ae2/EbsnMRLq3VBNnhyOCHn1Fj0BpqL0z-uH3nsfZHQVnB2yRQ?e=poC4A4 

​Hi,I have different items which needs to be packed in different bags based on the following criteria. I have an itemized spreadsheet with the weight of each item (attached in link). I am looking for a solution to get the items packed in bags, fulfilling the criteria as mentioned below. For that reason, I would like to get which bag can contain how many items- packet of items to be randomly packed in each bag such a way that the total weight shall not exceed 2.5 kg.- each bag shall have mix of items from each category with at least 2 category items in each bag.- Bag numbers shall be sequentially assigned in column F based on the first number which is manually assigned. (in example the bag number starts with 4001),To achieve the desired result can formula be used or VBA is required? Appreciate, any ideas /solution to get the desired result.Thanks in advance. https://1drv.ms/x/c/5184dd66ded11ae2/EbsnMRLq3VBNnhyOCHn1Fj0BpqL0z-uH3nsfZHQVnB2yRQ?e=poC4A4   Read More

​