• 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


  • 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


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.



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.

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.