Dear MrExcel members,
I've been searching for the solution on the web, but I don't know how to call it so it hasn't been a huge success. I was hoping you could help me.
I'm looking for a macro/vba code/solver solution for the following problem: I want to make groups of 4/5/6 products that are selected (preferably cut, not copied) from a pre-determined list.
Example:
My list is as follows:
1A34
2B43
1B544
5C45
3A52
5B32
Now I want Excel to automatically make groups containing 1xA, 2xB and 1xC, selected from top to bottom (because of priorities). Is there a way to cut those products out of the list, so I can see what products are still left to be grouped?
Thanks so much!
I've been searching for the solution on the web, but I don't know how to call it so it hasn't been a huge success. I was hoping you could help me.
I'm looking for a macro/vba code/solver solution for the following problem: I want to make groups of 4/5/6 products that are selected (preferably cut, not copied) from a pre-determined list.
Example:
My list is as follows:
1A34
2B43
1B544
5C45
3A52
5B32
Now I want Excel to automatically make groups containing 1xA, 2xB and 1xC, selected from top to bottom (because of priorities). Is there a way to cut those products out of the list, so I can see what products are still left to be grouped?
Thanks so much!
