Macro / VBA Help to update cell value based on dynamic table

[Leinad7]

Goal: This is similar to an inventory management file, but in Excel (CANNOT use Access - not all end-users have it). I have created a file to have inputs of FORMULA, ACTION (+ or -), PROJECT, and AMOUNT (lbs). This will then generate a list of all the raw materials for said FORMULA, their precentage, and then multiply the PERCENTAGE by the AMOUNT (lbs). I also have another RAW MATERIAL SHEET that holds all inventory information.

What I need: Once I have generated the list of all RAW MATERIALS changing, I want to update my RAW MATERIAL SHEET based on my new values.

I have attaced my Excel document for review.

Summary: I want my "Raw Material Inventory Change" sheet, column F, which is the "New Altered Inventory (lbs)" to update the values "Raw Material Sheet" on Column B "Inventory". I suspect this may involve a loop function with saving values then updating.

Any direciton would be amazing!

[Leinad7]

I understand this may be an 'intense' method, but could someone point me in the direction of how to do this? Do I use lookup, loop, Find & replace macros, Vlookup?

I know Excel may have difficulties having Cell A1 update AND CHANGE Cell B2. So, if B2=2, and A1=7, you run the macro to have B2=7, which is Cell A1 (NOT B2=A1).

Thanks!