I'm not sure if I'm explaining myself correctly. The materials are whats needed to make that part -- that's the point of the amount field. I want to make a quick and easy way to list how many materials I need. So If I want to make 5 bikes I need 5 Part A and 10. That is what the amount field is for. I'm going to have a big spreadsheet with about 50 different things with different materials and I need quick and easy consolidation of what materials I need.
I'm going to remake this whole sheet so you guys can see. Also, thank you for helping.
|Item||Material 1||Material 2||Amount Needed||**What I want a list of**|
|car||4 tires||1 exhaust||5||61 Tires|
|bike||1 chain||1 tire||1||2 Exhaust|
|test||1 blank||1 test||0||1 Chain|
|truck||4 tires||1 exhaust||10|