• 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.

Production Planning

Dear All Respected Members,
I required your support to solve one my issue. I want to make one production Planning sheet using VBA macro so could you please help me one this.

Criteria:-

1.Product details with SAM data, Order QTY ,and shipment dates.
2.From above data i want to make the plan for cutting preparation loading to line and production start date.
3. Production Plan has be done based one the master dat of SAM and Efficiency daily output qty also has to show.

Yellow data will be filled by user and Remaing other data has to come from macro program .

78624

I would like to thank your all of you for helping me in advance.
 
Pradeep Kumar Sahoo
#1 ... #3 missing some details for possible coding.
Yellow data will be filled by user ( = .above marked range ).
and
Remaing other data has to come from macro program ( missing all rules ).
> I did a visual sample based Your given details with some guesses
>> press [ Do_It ]-button
 

Attachments

  • Book1.xlsb
    22.2 KB · Views: 7
Back
Top