Hi, this is my first post here. Hope is in the right place
I want to use vlookup to find value from Cell "E43" in column(B20:B39), and replace the value
(adding 1 to the value that exists) in the corrisponding row, column (C20:C39) for a number of times
(value in cell "D41"). If value in the cell "D41"=0 do nothing. The initial values in the column ("C20:C39") are zeroes(0).
When The number in the column (C20:C39) change, the value in the cell "E43" changes also and writes that value
from the cell "B42" down until cell "B500"
That's the code i'm using to do all the stuff except replacing values in the column ("C20:C39"). I'm doing it manualy
In the attached file the value in ("E43") does not change because I used only a sheet from the original file.
Thanks for your observation Pepe Le Mokko.
Done
Bookmarks