This workbook will be used on a daily basis, the users will not have a great understanding of excel, so needs to be as user friendly as possible Once i figure out the formula i need and have the material aligned with the order number, i plan to create a macro, which will turn my raw SAP data into a working spreadsheet. Thanks Chris...