need cell increment or button-function

Hi, guys!

I'm in need of a function that automaticly increments a value from one cell to another, directly after typing in the value, or a button which does the same job.

In the picture you'll see a marked cells which I would want to type in a value between 1-50, and add that to the cells corresponding with the same row, one cell to the left of it. After the value is typed in and added to the other cell, it should automaticly be deleted (if thats possible).

increment.jpg

Does excel have such a function? If not, I need a button to each row, which will take an incredible amount of time to complete, as there will be around hundreds of rows which will need either one button or more, as I see it.

The use of this worksheet is storage-managing, and I have everything I need except that function. I would like to add a number of incoming articles in the column described. Any smart way to do this?


regards,

hiya, added a sample

https://docs.google.com/file/d/0B2J7...it?usp=sharing

Want to enter a value in G3, and add that value to F3.

Then automaticly delete the entered value in G3.

It's like a =F3+G3, but I don't want a formula in F3, only a function in G3.

Dunno if I'm explaining myself correctly :p

I thought it would be downloadable as a .xlsx - My mistake :/

sample.xlsx

Didn't see the attachement-icon untill I went to advanced.

Yes, exacly. But I want it to be repeatable without needing to delete the value.

Let's say this I want to add a value to an article called 'Coffiecup'. I read from a list of articles we just got, and I see from that list that we have 10 incoming Coffiecups. I add that value to a cell (where I want the function), and it adds itself to the number of previous stocked Coffiecups. Now, I read later on that another type of coffiecups just came on, and I want to add 12 more to that same article. Instead of the cell containing '10' (as of what we added before), it is empty, so I don't have to delete the value.

Sorry, it might be me thinking to complicated, or thinking of it too simplistic :p