Macro for updating a cell on a value match

[elitekatti]

Hi,

I have used excel for real basic stuffs hence very new to macros and such stuffs..
I ll describe my requirement in brief:

I have a 'name' field (person entry) and 'count' field (score) in the below format in Worksheet1:
Name Count
----- ------
abc 5
def 10
xyz 10

In Worksheet2, I have an 'output' field under which I enter the result - say as "true" or "false".

Output True
-----

Now in Worksheet3, I have the entries voted by each person as shown below (Note: the entires need not be in same order as in Worksheet1):

Name answer
------ -------
abc false
xyz true
def true

Now here, I need a MACRO for a Button_click (even a formula would do) which checks the correct result in worksheet2 (True/ false) and validate worksheet3 to see how many people have answered correctly and finally in worksheet1 increment the count for respective names who answered correctly.

Explaining in the above example:
The output is "true" and hence macro shall validate worksheet3 and find out that "xyz" and "def" have answered correctly. So update the count value by say 5 for "xyz" and "def" in worksheet1.
Hence Worksheet 1 shall now show:

Names Count
------ ------
abc 5
def 15
xyz 15

I would really appreciate answers to this question in the coming two days as I am constrained by time to get this thing working!

Thanks in advance!

 

[elitekatti]

Hi,

I have used excel for real basic stuffs hence very new to macros and such stuffs..
I ll describe my requirement in brief:

I have a 'name' field (person entry) and 'count' field (score) in the below format in Worksheet1:
Name Count
----- ------
abc 5
def 10
xyz 10

In Worksheet2, I have an 'output' field under which I enter the result - say as "true" or "false".

Output True
-----

Now in Worksheet3, I have the entries voted by each person as shown below (Note: the entires need not be in same order as in Worksheet1):

Name answer
------ -------
abc false
xyz true
def true

Now here, I need a MACRO for a Button_click (even a formula would do) which checks the correct result in worksheet2 (True/ false) and validate worksheet3 to see how many people have answered correctly and finally in worksheet1 increment the count for respective names who answered correctly.

Explaining in the above example:
The output is "true" and hence macro shall validate worksheet3 and find out that "xyz" and "def" have answered correctly. So update the count value by say 5 for "xyz" and "def" in worksheet1.
Hence Worksheet 1 shall now show:

Names Count
------ ------
abc 5
def 15
xyz 15

I would really appreciate answers to this question in the coming two days as I am constrained by time to get this thing working!

Thanks in advance!

I hope my question is easy-to-understand. Please let me know if there is any confusion in the question.
I am awaiting for solution to this one. early-the-better!
Thanks!

 

[elitekatti]

I have been trying to find a solution to this... facing some problems.. Looking forward for help atleast here!
I tried using IF function.
IF:-
logical condn : Worksheet3!b2:b4 = worksheet2!b2
value_if_true : Here i want check the cells (in column A) in worksheet 3 that PASS the above logical condition (i.e., whose corresponding B column values are True) AND for those selected names, in Worksheet 1 - add +5 to the corresponding next cell. This can be better understood by referring the example in the original question.
value_if_false : all other cells whose values does not satisfy the above logical condition, their corresponding names (value in corresponding A column) in worksheet 1 will have the corresponding next cell value subtracted by 5 or 0.

 

[elitekatti]

Disappointing to see no responses!
Is it that what I am asking is not possible in excel or is it too simple to ask such a question???
I was hoping atleast some way forward with regard to this problem!