Hello everyone,
I have been in the forum for a long time and I have learned some things for my excel sheets, but I cannot do what I need now.
I have a sheet in which I load items of products on line 5 per week and what I need is to have a macro that goes through all lines 4-3-2-1 these items, depending on the times (in days) indicated on the Date sheet you have for each item.
In the calculation of the macro, Saturdays and Sundays, and also holidays, must be discounted.
Is this possible?
Thanks,
Fernando
Hello,
What I'm trying to do is reverse planning.
For example:
In Line 5 I have a product to manufacture in a certain week and knowing the lead time of the product in each line, I can determine the week of completion in each of the lines 4-3-2-1.
Thank you
Fernando
Bookmarks