Hello everyone, I'm not able with vba and formulas so I try to explain my issue here.

I have a spreadsheet like this

(column) A B C D E
Description Total ValueWeek1 ValueWeek2 ValueWeek3

In this example I use 3 column for week but , They will be dynamic (ValueWeek will be added every time)

so , I wish create an excel that calculate partial ValueWeek after cell was edited. I don't know partial value of week , only aggregate total.
So if ValueWeek1 is 50 and in ValueWeek2 i write 58(Aggregate Total) , I need help to calculate ValueWeek2 as 8 (58-ValueWeek1) .
In the second time when I fill ValueWeek3 (for example 70 = 70-ValueWeek1-ValueWeek2) I need to see 12.

The real problem is that I don't know how many ValueWeek there will be.


Need I VBA Macros?
How can I create a dynamic range to calculate (Total -wk1 -wk2 - wkn)?

Is it possible change a value just filled in a cell?

I'm so sorry for languages I'm not able to write English.

Thanks for your time.
Regards
fabio