Hi,
I am working with a old macro written by someone no longer around (and secondly its not working consistently)
I have a reporting Hierarchy that looks like this
<tbody>
</tbody> I removed the commas and have each ID in its own cell going from Left to right.
I have a separate list of IDS where I would like the matching to stop once it finds the FIRST match. I.E. I want to stop when I find an employee that is the FIRST VP in this person's hierarchy.
<tbody>
</tbody> n/a n/a n/a YES
From there I will look for this ID and bring back the details (I think I can handle that part of the code)
I need to run through this process roughly 3,000+ times
I am working with a old macro written by someone no longer around (and secondly its not working consistently)
I have a reporting Hierarchy that looks like this
18615 | ,38630,29199,22163,26079,14516,16114,10614 |
<tbody>
</tbody>
I have a separate list of IDS where I would like the matching to stop once it finds the FIRST match. I.E. I want to stop when I find an employee that is the FIRST VP in this person's hierarchy.
18615 | ,38630,29199,22163,26079,14516,16114,10614 |
<tbody>
</tbody>
From there I will look for this ID and bring back the details (I think I can handle that part of the code)
I need to run through this process roughly 3,000+ times