mjh4ck3r
06-02-2020, 01:12 AM
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
Email
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
Email
E1
0
Email
E2
0
Email
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".
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".