Hi,
Im fairly very new to VBA Scripting. i have a problem please find the below table
Output column is Comments
The comment column gets the value from the below table
from first table it should look for the value in second table and check the value column for the last occurrence of 1 say in Alerts A1 is the last has 1 then A1 has to appear in the comment column in table 1, if all three are of alerts are done then its Comments is "Done".
Im fairly very new to VBA Scripting. i have a problem please find the below table
Output column is Comments
| Name | Comments |
| Alert | A1 |
| Phone | P2 |
| Not started |
The comment column gets the value from the below table
| Name | subname | value |
| Alert | A1 | 1 |
| Alert | A2 | 0 |
| Alert | A3 | 0 |
| Phone | P1 | 1 |
| Phone | P2 | 1 |
| Phone | P3 | 0 |
| Phone | P4 | 0 |
| E1 | 0 | |
| E2 | 0 | |
| E3 | 0 |
from first table it should look for the value in second table and check the value column for the last occurrence of 1 say in Alerts A1 is the last has 1 then A1 has to appear in the comment column in table 1, if all three are of alerts are done then its Comments is "Done".
