Pick Lists and Automated Order Sheet

[Rbro]

Evening, hoping for some help in regards to part management.

I rebuild Engine parts, such as Cylinder Heads.

Each Cylinder Heads needs up to 50 Different parts to complete the rebuild, however each head we receive is different. Therefore one head might need 11 of 50 parts, where as the next head might only need 6. I would like to identify parts from a main list as required, with a qty required. I would like only the parts that have been identified as required to then be moved to a master order sheet so it can be printed as a pdf.

 

[Armstrong_N14]

You can do Pivot or
Maybe This?

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Part Name	Part Number	Required	Qty	Vendor A	Vendor B	Vendor C			Master Order Sheet
2	Hex Bolt	B-12x100	Y	4	Bolt & Nut	Brofasco	Fastenal			Part Name	Part Number	Required	Qty	Vendor A	Vendor B	Vendor C
3	Studs	S-16x120	N	0	Bolt & Nut	Brofasco	Fastenal			Hex Bolt	B-12x100	Y	4	Bolt & Nut	Brofasco	Fastenal
4	Valve Seats	VS-180	Y	2	Raco	Gibbs	Martens			Valve Seats	VS-180	Y	2	Raco	Gibbs	Martens
5	Valve Guides	VG-016	Y	4	Raco	Gibbs	Martens			Valve Guides	VG-016	Y	4	Raco	Gibbs	Martens
6	Valves	V-180	N	4	Raco	Gibbs	Martens
7	Injector Sleeves	IS-118	N	0	MIS	Andy	Roy Boys
Sheet1

Cell Formulas
Range	Formula
J2:P5	J2	=FILTER($A$1:$G$7,(C1:C7="Y")+(C1:C7="Required"))
Dynamic array formulas.

 

[Rbro]

You can do Pivot or
Maybe This?

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Part Name	Part Number	Required	Qty	Vendor A	Vendor B	Vendor C			Master Order Sheet
2	Hex Bolt	B-12x100	Y	4	Bolt & Nut	Brofasco	Fastenal			Part Name	Part Number	Required	Qty	Vendor A	Vendor B	Vendor C
3	Studs	S-16x120	N	0	Bolt & Nut	Brofasco	Fastenal			Hex Bolt	B-12x100	Y	4	Bolt & Nut	Brofasco	Fastenal
4	Valve Seats	VS-180	Y	2	Raco	Gibbs	Martens			Valve Seats	VS-180	Y	2	Raco	Gibbs	Martens
5	Valve Guides	VG-016	Y	4	Raco	Gibbs	Martens			Valve Guides	VG-016	Y	4	Raco	Gibbs	Martens
6	Valves	V-180	N	4	Raco	Gibbs	Martens
7	Injector Sleeves	IS-118	N	0	MIS	Andy	Roy Boys
Sheet1

Cell Formulas
Range	Formula
J2:P5	J2	=FILTER($A$1:$G$7,(C1:C7="Y")+(C1:C7="Required"))
Dynamic array formulas.

Thanks!!!!