Hello,
You can check the attached sheet and see on the Info sheet there are the cells with Your Mats: SS,MS,SO,EO and to the right the amount of each material owned(which is editable and will change based on user and available materials at a give time). Now on the Testing Sheet i have the table with the data, what i need is that P.C.(G column) will change according to the materials you have(the initial cost is from B:E) so if i have all the materials that i need to craft that product the production will reduces the cost of those materials automatically, if i have just a part of the material then again reduces the cost of what i have and display the remaining amount i require. I hope i made myself clear on this and explained properly my problem. Thank you for your time.
Bookmarks