VISHAL120
09-16-2011, 05:56 AM
Hi Gurus,
I needed help on that through VBA concerning the prod. flow. system.
Actually concerning the production flow i have an end knit date from which all end date for other dept is calculated BUT taking into consideration the Route type which gives the leadtime for each Dept.
Example:
End knit date : 20-06 Route type is 6 then its End knit + leadtime as per route type for each dept.
See Attached File for Better example. I have been struggling on that since weeks till now and i needed just a hint of how can i proceed with. Again it shall be with VBA not formula as this will be incorparated in another master file.
Many thanks in advance for the tips.
I needed help on that through VBA concerning the prod. flow. system.
Actually concerning the production flow i have an end knit date from which all end date for other dept is calculated BUT taking into consideration the Route type which gives the leadtime for each Dept.
Example:
End knit date : 20-06 Route type is 6 then its End knit + leadtime as per route type for each dept.
See Attached File for Better example. I have been struggling on that since weeks till now and i needed just a hint of how can i proceed with. Again it shall be with VBA not formula as this will be incorparated in another master file.
Many thanks in advance for the tips.