i need to prove a concept could work for a meeting Monday 25th, that could be develop into a much bigger project if signed on.
the attached sheet shows a grid of data of our manufacturing process that orders go through. Orders don't go through the absolute same steps each time (order #1, 2 and 4 have 5 steps, but orders 3 and 5 have just 4 steps, and the data table shows the break down of steps for each order.
each step for each order has a Date. As you'll see on the summary page, we then plot the step for each order on a calendar style grid so we can see what needs to be done on what day.
So we need a few things to prove the concept could work please...
1/. automatically plot the order number against the right date and Dept. if we change the date, the job needs to automatically move the order to the correct place
2/. when a new order comes in the list of data will grow and the summary should expand to allow for the new data. e.g. based on the current data Create Frames dept has a max of two tasks on its busiest day. but it could swell to be 5 or 6 if the data required.
3/. on the summary grid we want each order to be coloured so it's easy to spot how each order flows over time. don't mind how the colours are changed, just so it's easy to read (this feature could come later if time is an issue given my Monday morning UK time demo requirement).
ADDED 22/7 13:50...
Dates on the Data sheet might need to be calculated to some degree. For instance a Doorset cant be made without a Door AND a Frame, so we might want to set the doorset date to be the Max date of either Create Door or Create Frame (whichever is later) plus add on day to give ourselves some room for delays before the Create Doorset Tasks happens. its just an option we might need so hopefully doesn't impact what you develop but i wanted to be clear.
New Ask : i found this website which could prove useful for us http://wellsr.com/vba/2015/excel/draw-lines-or-arrows-between-cells-with-vba/
We would love to be able to show / hide lines to highlight the path of an order is taking through our production process so it's easier to read details for that order. So i would like a way, for any one order, show lines between the cells to show it's path through production