Good Morning Debra,
Thanks for your reply.
You lost me, when I read your answer it sounds so simple but I don't see how
it relates to A19 & A20 in my sample.
I'm looking to find a way for those two cells to populate automatically from
the input sheet

"Debra Dalgleish" wrote:

Create a pivot table from the data, with Diameter in the row area,
length in the column area, and Count of Diameter in the data area.
In the page area, add Flat washer, and from its dropdown list, choose 1

Copy that pivot table, and paste the copy on a different sheet.
In the copy, remove Flat washer from the page area, and add Beveled
washer, and from its dropdown list, choose 1.

Serge wrote:
I have an "Input sheet" with various bolt diameters, bolt grades & bolt
lengths.
example:
D E G H
J
Dia. Grade (Flat Washer) (Beveled washer) Length
.625 A325 black 1
1.5
.5 A325 galv 1
1.75
.75 SAE 1
2.0
.75 A325 galv 1
2.25
.75 A325 black 1
2.0

In the output sheet (same workbook) one area is assigned for each bolt
grade that has a flat washer, one for beveled washer:
Sample:
A325 HEX HEAD BOLT ASSY (Galv with Nut & Flat Washer)
A B C
Dia Length Qty
row 19 (formula ?) (formula ?)
row 20 (formula ?) (formula ?)
row 21 (formula ?) (formula ?)
etc. etc.
I column "C" there is a formula that will give a quantity for that specific
bolt grade providing I manually input the "bolt dia" in "A" and the "bolt
length" in "B" to match the information on the input sheet.
I would like to retreive the Dia & length in the first row and some how in
the second row the formula needs to look for different bolt dia that may have
different or same length as the previous row and so on. Column "C" will
simply give me a quantity for those bolts.

From previous posting I tried pivot table suggestions but my brain just
caanot get arround this.

Could someone help please, I'm realy desperate.

Thanks

Serge



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html