• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need VBA code or Micro for Cookie distribution

shabanash

New Member
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.
 

Attachments

shabanash

New Member
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
 
Top