I am trying to manage an inventory list and running into trouble getting the current inventory to automatically update in the same cell. Currently, I am trying to figure out a way to store the result of a formula in another cell as a value. This cell will be used as part of the original formula to recalculate as other values change.
Example: C1+E1-G1=# :I want to store # in C1 every time this is calculated (this would be my current inventory)
I have seen VBA codes that might work but I have never used VBA and have no idea what any of it means or how to make it work. The following post describes almost exactly what I am trying to do, http://www.mrexcel.com/forum/excel-questions/426650-record-cells-prior-value-can-done.html, but I don't know how to implement the code.
Is there a way to do this without codes? Any help would be appreciated.
I am using Excel 2011
Example: C1+E1-G1=# :I want to store # in C1 every time this is calculated (this would be my current inventory)
I have seen VBA codes that might work but I have never used VBA and have no idea what any of it means or how to make it work. The following post describes almost exactly what I am trying to do, http://www.mrexcel.com/forum/excel-questions/426650-record-cells-prior-value-can-done.html, but I don't know how to implement the code.
Is there a way to do this without codes? Any help would be appreciated.
I am using Excel 2011
