I am proficient with excel macro/VBA programming, I have gone through sheet 'New production' and sheet 'Example' in your attached workbook, I can write the code to generate the report as described in your worksheet 'Example', please message me for further detailed discussion of your project, await for your precious reply.