Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere it the macro i made for this solution
My solution below:
Well, It's pretty obvious I wasn't looking at other solved solutions... Haha! Oh well, glad to of solved it.
Hi Everyone! I have a very similar use case to this and have been trying to work out how I could tweak the macro.
In my case I have Employee ID and Manager ID. What I want to do is start with the top (CEO) ID (assign as Level 1), then identify who they manage (Level 2), and so on and so forth until the bottom of the hierarchy.
Could anyone advise how I could modify the solution for this use case?
Thank you :)
The practice of macro creation was big reason that I started the weekly challenges. I'd like to say this went easily, but it was a big struggle. However, with the help of your solution, I was able to get through it and then created it a second time. I believe I learned a great deal.