Need to generate Open Order Report Filtered By Customer and Due date

[frank_m]

I need to be able to produce a printed Open Order Report Filtered By Customer and ((Open Status that is marked in column A)) and by the Promise date.

I want to be able to entering the customer name in Cell C1 and click a button to create a new sheet with the report ready for printing..

Several of the columns need to be hidden, I can handle that part of the coding and I can code the printing setup, just would be very appreciative for help with the rest.

I was thinking maybe a pivot table could do this, but I do not know and I have zero experience with that, plus I need it coded in any case.

I've attached a sample workbook with some sample data and a sample report.

Thank you much