Printing only *needed* rows

[a_Sparky]

I have a sheet with 5 columns: A Quanity, B Description, C Cost, D Unit, and E Total. The sheet has close to 300 rows. What I would like is, if a quanity is entered in A, only that row along with any other rows that have quanities entered, be compliled into a new sheet that can be printed with a grand total at the bottom of all the items. The Column headings and Header/Footer should also be printed on the summary page.

 

[sen_edp]

You can use auto filter feature, and at the
end of the list use subtotal function to sum only the visible rows ( put the 9 value in argument)