Hi, I posted this sheet on this site already and someone provided assistance, so hopefully someone can help resolve my latest issue with the excel project from hell. I attach the file, you only need to view the sheets tabbed in red. Basically on Jobtime, you click the button opposite and it creates a schedule of work on the sheet timeline.
First step for the order is handling, then its threaded, then swedged then phosphated. When I click the first button everything works perfect, the WO number is transferred to the appropraite machines, for the appropriate period of time, using last row, offsets and numpastes. The problem occurs when i press the next button which adds in the second order. I attached a sccreenshot to highlight the issue,but basically the code is not finding the first blank cell in my ranges but instead the first blank in a row in my ranges (after offsets)
I have been trying to resolve for days, if anyone solves I will be very happy, but also hate you ;) trials1.xlsm