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.