Two cell accumulator then reset first cells

Hi all,
I havent used macros in a long time and have a large excel document to do at work.
I could do with some help with a small part of the sheet which is comparative to other areas of the sheet.

To simplify this so that I can then take the advice and utilise it throughout the sheet. I need help with the following please.

I basically have four cells
c8 = goods in (new components in)
c9 = kanban stock (current qty in stores)
c10 = current stock (=kanban stock minus allocated)
c11 = allocated (number on order)

What I would like to be able to do is enter a figure in c8. This would then start the macro to update c9,10 and 11.
The problem I have is that if i enter a figure into c8 sure it alters the others if i do a quick =sum formula but does not reset. Therefore if I put for example 6 in cell c8 and then want to add another 8 all other cells alter accordingly. I want all cells apart from c8 to update and hold the figure after c8 has been entered.

Hope this makes sense

Regards

Shaun

Hi
Thanks for your reply
I followed what you said and nothing happens?
Regards
Shaun

Hi
I posted a request for help a couple of days ago and probably confused the issue

What I am trying to do is have two cells ( Say C8 and C9)
I want to use c8 to add number data and I want c9 to keep its original number and add the figure in c8 to it.
Then I would like c8 to reset but c9 to keep the new number
When I then enter a new number into c8 I want to repeat the process

So for example I enter the number 2 into c8 then c8 and c9 should = 2. Cell c8 resets but c9 keeps the figure 2

If i now add the number 2 to c8 again then c8 should reset and c9 should = 4 and so on.

Is this possible ?

Any help greatly appreciated

Shaun

You my friend are an absolute star
I am not worthy

Thanks so much

Shaun

Ok... As you answered that so quickly a couple more questions for you

Now I have the formula you did for me the true extent of the problem is as follows

Instead of just c8 and c9 as mentioned the true cells are
K5 and I5

Is it just as simple as going to code page and changing the values.

I then want to reproduce this all the way down the screen so

K5 alter I5 all the way down to k150 alters I150

Now you have done the first part is this a simple continuation?

Thanks
Shaun

This works perfectly. Your good at this

Final question. If i wanted to change the range to say k`55 and not K150 do I just view code and replace 150 with 155?

This is sure to be the final question

Thanks

K'55 was meant to read K150 of course