Stop and hold the result from a formula in cell

[v!o]

Hello, boys

The first time I will explain what it is about:
- I have a .xls with 2 sheets.
- In the "V.war" sheet I always paste and check the new information regularly.
- In the "Tmp.war" sheet I extract data from the "V.war" sheet and I want to check what is the difference from one round to another depending on the total result.
- In the "Tmp.war" sheet, the cells colored in red are filled in automatically. I fill the green colored cells manually.

What I want:
-from cells H3 to P3 I would like that when I paste new information related to rounds that the results from the previous rounds remain and do not change.
A formula that make a difference between the total result G3 and other cell previously completed H3, I3, J3...P3.
Example:
H3 (1/9) to be 5000 (what i paste for this round)
I3 (2/9) to be 5000 (what i paste for this round)
J3 (3/9) to be 5000 (what i paste for this round)
K3 (4/9) to be 5000 (what i paste for this round)
etc etc


Tnx

[v!o]

Or may by a IF + VLOOKUP for 1/9, 2/9...9/9 for each cell H3, I3...P3

And in sheet "V.war" to not replace data, only to add the new data.

I must check this...

[Glenn Kennedy]

I am a bit confused by this. It seems like you want those cells to contain a formula AND a value. They can't . One or the other.

[v!o]

Hello,
It's like to be something like you said.

Tnx for help