Qty To Be Separated across multiple Cell Based On Multiple Criteria

[Rajeshkumar R]

Dear Friends,

Please find my attached Excel File Where

Column A Contains “Product Code”
Column B Contains “Segment”
Column C Contains “Qty which needs to separated”
Column D contains “Std. Hours”
Column E contains “Max Output” Qty to be separated per day in align with this qty
Column F contains “Start Date” Qty To be separated from this particular date only
Column K onwards sequential dates are updated
Row No. 2 Contains “Each Day Wise what is the available Man Power”
Row No. 3 contains “Formula which will auto populate loaded HC” based on qty which is getting separated on each Day

Support Required: -

Each Product, Column C mentioned qty should be separated by validating following criteria in sequence

Criteria 1 - Qty To be separated must be >0

Criteria 2 – Qty separation to be started from start date onwards subjected to 2 layer validation. Validation 1 Available Man Power is > Loaded Manpower, Validation 2 After aligning the qty Loaded Man Power should be<=Available Man Power

Criteria 3 :- If Start date is already met with above criteria; excel should look for next available date where criteria 2 Meets and separate the qty
In Summary All “Qty To Be Separated” value separated into each date based on above criteria’s

Your suggestion can be in the form of Formula or VBA too Fine!

Thanks & Regards,
Rajeshkumar R

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[Rajeshkumar R]

Dear Bo_Ry,

Awesome! Thanks a lot for your quick support, it is working amazingly! I never imagined this can be achieved so easily like this with 100% accurate!

Having said That; I need one extended support please, i.e., in my current attached file, Where I have more than one segment (A B & C)

There are more than 1 segment in the file; Along with my already explained criteria, Segment wise separation to be included as additional criteria,

Could you please suggest me with these added criteria?

Thanks & Regards,
Rajeshkumar R

[Rajeshkumar R]

Dear Bo_Ry

Is there any hope to extended support on above Criteria's?

Looking forwrd your valuable Input Please!

Thanks & Regards,
Rajeshkumar R

[Bo_Ry]

Last try

Please Login or Register  to view this content.

[Rajeshkumar R]

Dear Bo_Ry,

Thanks a lot for your patience and extended support, I could get the output what exactly I was looking For!

Thanks & Regards,
Rajeshkumar R