Can you make a small modification? When copying the new values, I would like to copy the cell in column B (which is a small "index" that can be 1A,2A,3A or 4A) together with the one in cell C, so that on Sheet3 I have on column A that index together with the new number on column B. I don't need to compare those "indexes" (because they don't vary with the same number), I just need to compare the number and then insert the new number together with it's index on Sheet3.
Example:
columns B and C (CADIM):
4A 10
3A 9
2A 6
1A 2

columns A and B (sheet3):
4A 11
4A 10
2A 6
1A 2
1A 1

Thanks again!