Need VBA code or Micro for Cookie distribution

[shabanash]

Hi Friends,
Thank you for all your selfless support to the community.
I need VBA code or Micro for Cookie distribution. The sample file and other guidelines are mentioned therein. I will input few values and I need result in Output sheet. Right now I have done and am doing it manually. Please help me to ease this tedious task. Looking forward to help and guidance.

 

[Chihiro]

Your constraints are unclear to me.

But this looks like sort of problem for Solver. See if you can apply method in thread below.
https://chandoo.org/forum/threads/container-assignment-with-constraint.44477/#post-265588

Since your variable matrix can exceed standard Solver limit (200+). You'll want to install Open Solver add-in mentioned in the thread.

 

[pecoflyer]

Why don't you post in the VBA section?

 

[Chihiro]

Done Didn't even check that.

 

[shabanash]

Why don't you post in the VBA section?

Hi
Sorry. This is my first post and I was not sure which one will be better.
Thank you

 

[shabanash]

Your constraints are unclear to me.

But this looks like sort of problem for Solver. See if you can apply method in thread below.
https://chandoo.org/forum/threads/container-assignment-with-constraint.44477/#post-265588

Since your variable matrix can exceed standard Solver limit (200+). You'll want to install Open Solver add-in mentioned in the thread.

Hi Chihiro san
Thank you for providing the resolution in your busy schedule.
I will definitely try it and will post the outcome.
Regards,
Shabana