Hi All, | ||||||||||||||||||||||||||||||||||||||||||||
I've been tasked with making a very basic MRP and hope someone can help me automate it a bit. Our products only go down one level, so I think it's doable, but the way I have made it is very cumbersome and wondered if there is a formula I could use to help automate it. What I am currently entering takes hours. I need to have a sum that looks at the productcode which is a component code. (240SSD)
<tbody> </tbody> The sum then looks at another work sheet to see what finished product that component goes into.
<tbody> </tbody> Then it multiplies the component quantity in finished product * sales order demand (for that month) for the finished product.
<tbody> </tbody> So the final formula is something like =(SHEETA!C2*SHEETB!B2)+(SHEETA!C3*SHEETB!B3)+(SHEETA!C4*SHEETB!C4) This works for now, but it requires me going through and selecting each cell which takes hours, then if products are added or i miss one there could easily be an error and I wouldn't know about. Its a tall order, but if anyone knows a way I can join this up and automate it using an advanced vlook up or sumifs etc, that would be huge! Thanks Natheplas |
<colgroup><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>