Hi guys i need a little bit of help with excel. I have a worksheet which haves 3 columns. A:word in english;B:word in my language;C:checking if the word i wrote is correct(T or F). i need to make on another sheet everytime there is "f" a word to increment a cell value. It would be better if it can be done to calculate the incrementing on button click.
For example : A:"one";B:"2";C:"F". and on button click everytime i write "2" and click on the button i want the number in cell in another sheet to increment by 1.
This is the first sheet :colum a(number with letters)
colum b(number with digits)
colum c(True or False)
one
2
F
two
2
F
"one" is "F" in third column because obviously "one" is not "2" (in number).
I want on second sheet this :column a(number)
column b(count how many times the result was "F")
one
1
two
0
I want everytime i recalculate or click on a Command Button(Activex control), column b to increment with +1 if the result is "F" again, and if it is "T" to stay the same value (+0)
I am not 100% sure if this whole thing can happen, and if it can i am not sure it haves to be with vba/macros :/
I have attached example .xls file.
Bookmarks