I have attached the data i am working with. Cells a16:P25 are values of resources that are entered by hand. Cells B3:B8 tell me how many items i may purchase based on the amount of available resources. I am trying to get it so that when i enter a value into Cells C3:C8, they will update the values in B3:B8 with the amount of resources that are left over after the purchase has been made.
Any help is greatly appreciated.
Kind of confused... would it not be just updating the formula in B3:B8 to subtract value in corresponding C3:C8
e.g. change formula in B3 to =MIN(Sheet3!E6:E15)-C3 , etc...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
The cells are not strict values, but formulas that are from data on a separate worksheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
rexwells 
Register To Reply
Bookmarks