Alright, I hope this makes SOME sort of sense...
Basically what I am trying to do, is to create a locked cell, then add two cells underneath it, one which would be coded specifically for *ADDING* to the value of the locked cell, and one for *SUBTRACTING* from it.
Ideally, the way it would work, is that the user could type in an amount in the "add" cell, which would then populate into the locked cell, automatically, and immediately clearing the "add" cell. In order to subtract from the locked cell, they would have to use the "subtract" cell. Using the "add" cell again would (IDEALLY) add the NEW number they were inputting to the previous number which had already populated the locked cell.
In other words, inserting "10" into the "add" cell would then populate the locked cell with "10." - Inserting "10" into the "add" cell AGAIN would change the locked cell to "20." - The only way to subtract from the locked cell (ideally) would be to use the "subtract" cell.
If this makes any sense, and ANYONE knows of a way (complex or otherwise; though, I doubt sincerely it could possibly be otherwise), please let me know.
Thanks!!
Bookmarks