quote sheet help please

[R_Brown]

I need your help again please folks,

I have a basic program to help doing quotes for our small business. Basically, I would like to streamline the program, and also be able to print only the parts that are selected for a particular job on Sheet#2.

The program has several different catagories, then all the options are listed in each category. The user selects which options are required, and the program totals everything up. BUT... I would like to be able to display each of the parts selected on a separate worksheet so that I can easily print off all of the options that we require for the quote. This makes ordering and final billing alot easier for us.

Basically, what I "think" needs to happen is some sort of sorting formula in place on Sheet#2 that takes each item from Sheet#1 that has a number other than "0" in the quantity column, and add it to the printable worksheet, under the proper category.

I have included a simplified version of the quote sheet, please note on sheet 2 the stucture is in place, but no formula to add in the items if they are selected on sheet 1.

I hope this makes sense, please ask if I have not been clear enough,

thanks,

RB

[Domenic]

Try the following...

A6, copied down to A8 and over to Column D:

=IF(ROW()-ROW(A$6)+1<=COUNTIF(Sheet1!$A$5:$A$7,">0"),INDEX(Sheet1!A$5:A$7,SMALL(IF(Sheet1!$A$5:$A$7>0,ROW(Sheet1!$A$5:$A$7)-ROW(Sheet1!$A$5)+1),ROWS(Sheet2!A$6:A6))),"")

A11, copied down to A13 and over to Column D:

=IF(ROW()-ROW(A$11)+1<=COUNTIF(Sheet1!$A$10:$A$12,">0"),INDEX(Sheet1!A$10:A$12,SMALL(IF(Sheet1!$A$10:$A$12>0,ROW(Sheet1!$A$10:$A$12)-ROW(Sheet1!$A$10)+1),ROWS(Sheet2!A$11:A11))),"")

A16, copied down to A18 and over to Column D:

=IF(ROW()-ROW(A$16)+1<=COUNTIF(Sheet1!$A$15:$A$17,">0"),INDEX(Sheet1!A$15:A$17,SMALL(IF(Sheet1!$A$15:$A$17>0,ROW(Sheet1!$A$15:$A$17)-ROW(Sheet1!$A$15)+1),ROWS(Sheet2!A$16:A16))),"")

These formulas need to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

[R_Brown]

Thank you very much Domenic, I just checked back with the site and saw your excellent reply.
RB