VBA Program for check updated values and subtract with ather values

[elsenthil]

Hi Experts,
I need a help from you. I am having the with the following sample details,
For example,
School Name: A, B, C & D
Student Name: A1, B1, C1 & D1
Status: True & False
And the data is update on excel sheet as the following format,
A B C D E
1 School Name Student Name Status (True or False) Counting Difference
2 C A1 TRUE 8
3 B A1 TRUE 2
4 A D1 TRUE 20
5 C C1 TRUE 4
6 B A1 FALSE 30 28 D6-D2 (30-2=28)
7 B C1 TRUE 8
8 A B1 TRUE 5
9 C A1 FALSE 24 16 D9-D2 (24-8=16)
10 B C1 FALSE 45 37 D10-D7 (45-8=37)
11 B A1 TRUE 14
12 B A1 FALSE 38 24 D12-D11 (38-14=24)
13



Condition 1:
First it has to check what school name, student name and status (False) is updating the first row and it has to check the same school name, same student name and different status (True) on previous updated row. If same school name, same student name and different status (True) on previous updated row I need to subtract false value to true value (as per shown the difference example here)
(Note: This is example data’s only. Any school name, student name and status can be updated the rows)
Condition 2:
If False is updated on the cell on column C I need a popup message box like “School ‘A’ Student ‘B1’ is FALSE now”.


I hope anybody help me the following my question