Hi,
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 Alert A2 Alert A3 Phone P1 Phone P2 Phone P3 Phone P4 E1 E2 E3
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".
Reply With Quote
