|Great, that clear cell thing was good!|
Anyways, to just make clear what I try to make. Great help so far, I might add.
I'm employed at a software reseller company (newly started, and fairly small), and I'm trying to make a spreadsheet which assesses how much of each software we have in stock. I was planning to set it up like this:
"Software #1: In stock | New supply | Sold"
Where the "In stock" is our "a1", "New supply" is "a2" and "Sold" is a3.
My plan was to easily type in arrived software in a2, to add it up to the current value in a1. As well as type in amount of software sold in a3, to subtract from the current value in a1.
This would have to be done for many different software types, as we carry a bunch.
So, I would try to achieve:
A1 + A2 = Updated A1.
A1 - A3 = Updated A1
B1 + B2 = Updated B1
B1 - B3 = Updated B1
I reckon if you can do it with more than one, you can pretty much do it infinitely, or how long I can be bothered punching in numbers.
Hopefully that cleared it up, and hopefully it can be done without someone writing an essay of code. :)
Edit: Also, for simplicity's sake, I can write a negative number in the addition box, if that would make it a lot simpler.