Hello All
MFG tab this raw data that is pasted in... This can't be a table or a pivot
JLR Report Tab – in E3 this current counts the part numbers built on 06:30 – 1430 shift, then times it by the “normal box quantity” currently 13
F3 counts items built between 14:30-22:30
G3 counts items between 22:30-06:00
Sometimes my production produces higher or lower box quantities, but this report assumes they are building in full box quantities of 13
Is there way it could sum what’s been built column E on MFG Tab, but maintain the detail for each shift
Please see attached
Paul
Bookmarks