I have two columns called "Job" and "Activity" - There can be multiple activities for one job (But they differ for each job) e.g.
For Job X the Activity can be Certification, Assembly, Painting, etc. For EACH of the Numbered Items it can be Assembly, Inspection, Painting, etc.
Is there a script to loop through and select the correct Activity? I have a Userform if the Job Combo-box is selected it must only show the selected activities in the Activity Combo-box?? Any suggestion on how to do it will be greatly appreciated.
<tbody>
</tbody>
For Job X the Activity can be Certification, Assembly, Painting, etc. For EACH of the Numbered Items it can be Assembly, Inspection, Painting, etc.
Is there a script to loop through and select the correct Activity? I have a Userform if the Job Combo-box is selected it must only show the selected activities in the Activity Combo-box?? Any suggestion on how to do it will be greatly appreciated.
Job | Activity ID |
X | Certification |
X | Assembly |
X | Painting |
X | Testing |
X | Certification |
X | Inspection |
Tooling | Fabrication |
Tooling | Inspection |
Tooling | Maintenance |
Tooling | Testing |
Tooling | Design |
1581120-30/01 | Assembly |
1581130-30/01 | Inspection |
1582525-01/01 | Painting |
1582550-01/01 | Testing |
1582700-0712/01 | Certification |
1583100-06/02 | Fabrication |
1583110-01/01 | |
1583110-2001/01 | |
1583120-20/02 | |
1583120-22/02 | |
1583120-23/02 |
<tbody>
</tbody>