Adding and subtracting numbers in a cell.

[asd75]

Hello, I'm new to excel and I don't even know if this is a good program to do sth like that, but I want to create a table where in every cell there would be possibility to add and sutract numbers manually. Sth like in this pic (just an example ):
Imgur: The most awesome images on the Internet
Is it possible?

 

[oldbrewer]

44

55

76

add

33

23

11

problem statement

select one of the 6 cells

and add or subtract in steps of 1

test

select 22 and add to it

by putting "add" in E1 and clicking macro button

click here <tbody> </tbody>

< < < a shape with macro assigned to it

B2 was 22

this macro increased it to 23

If Cells(1, 5) = "add" Then GoTo 100 Else GoTo 200

100 temp = ActiveCell

temp = temp + 1

ActiveCell = temp

GoTo 300

200 temp = ActiveCell

temp = temp - 1

ActiveCell = temp

300 End Sub

<colgroup><col span="14"></colgroup><tbody>
</tbody>