Printing only *needed* rows

a_Sparky · May 7th, 2002, 07:37 AM

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 · May 7th, 2002, 07:51 AM

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)

May 7th, 2002, 07:51 AM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	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) __________________ Best Regards Andreas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 07:37 AM	#1
a_Sparky New Member Join Date: May 2002 Posts: 1	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.