I am a very new to excel macro and I need help.
we have 3 shifts at the factory.
06:00-14:00 morning shift
14:00-22:00 late shift
22:00-06:00 night shift
We don't want to use papaer and I made userform to enter the breakage and rework data easily. I would like to see the 3 shifts breakage and rework graph in an another excel workbook. But I want to see the actual date datas. In every shift I would like to see the past 2 shifts and the actual shift. Is it possible?(3 Graphs>> actual shift and the past 2 shifts)
like a dashboard
Thank you for your helps!