Challenge #12: Creating an HR Hierarchy

[Numa]

[Archie_bos]

here is my solution

[Myles_Stevenson]

Spoiler

Here it the macro i made for this solution

 

[Rob-Silk]

My solution below:

Spoiler

[JimmyV]

Well, It's pretty obvious I wasn't looking at other solved solutions... Haha! Oh well, glad to of solved it.

Spoiler

[caitlynmcintyre]

Spoiler

[SamMitchell2]

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 :)

[westlakecjw]

Spoiler

[SidSaythongphet]

Spoiler

 

[BrianJohnson]

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.