• 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

  • Cookie Distribution.xlsx
    14.7 KB · Views: 6
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
 
Back
Top