title: How can I generate a material shopping list using Excel?
body: <p>This seems like it should be a fairly simple task, but I have not been able to figure it out. It should be noted that I am still new to excel, so forgive my ignorance.</p>
  
  <p>I am an insulation contractor trying to streamline some of the paperwork I have to fill out for each job.
  My goal is to have a workbook where I can enter data gathered from the jobsite, have it do the various calculations needed, then fill out necessary forms. The problem I am running into, is generating a Material Order List. I have simplified my example, but it illustrates what I need, and the information I am working with.</p>
  
  <p>My dilema is two-part</p>
  
  <ol>
  <li><p>How can I generate a new list of materials needed, along with the associated quantities and prices?</p></li>
  <li><p>If I have the same material being used in different sections of the job, how can I consolidate them into one item on the Material Order List? (See rows 3 and 8, and rows 6 and 7)</p></li>
  </ol>
  
  <p><a href="https://drive.google.com/file/d/0B_s-vHLiskO2MV9EbHBJVGpUMmc/edit?usp=sharing" rel="nofollow">https://drive.google.com/file/d/0B_s-vHLiskO2MV9EbHBJVGpUMmc/edit?usp=sharing</a></p>
  
  <p>If there is a non- Visual Basic answer, that would be ideal, as I have no experience with it. I have worked with VLOOKUP, Nested IF statement, and some others quite bit so far, but can't seem to find a function to do what I want.</p>