Hiya all,
I have a workbook in which my staff are responsible for maintaining. At the start of each week I have a snapshot of the week ahead. I have 3 columns which I am particularly interested in which shows Open Stock / Shortage Current Week / Shortage next week.
They are responsible for maintaining planned deliveries and actual deliveries, I have managed to get the sheet to recognize when actual delivery happens, but I am looking for a method of changing the original 3 columns accordingly. Hopefully example below
No sure if picture worked
I have a workbook in which my staff are responsible for maintaining. At the start of each week I have a snapshot of the week ahead. I have 3 columns which I am particularly interested in which shows Open Stock / Shortage Current Week / Shortage next week.
They are responsible for maintaining planned deliveries and actual deliveries, I have managed to get the sheet to recognize when actual delivery happens, but I am looking for a method of changing the original 3 columns accordingly. Hopefully example below
No sure if picture worked
Last edited: