Challenge #12: Creating an HR Hierarchy

[MattBenj]

First iterative macro.

[Trumble_dup_334]

Watched a video on Iterative Macros so understood the concept, knew what I needed to do, couldn't seem to get there, so referred to the solution and built it from there!! Very good challenge, although I admit defeat, but a nice intro to something so powerful.

[AV8]

Really challenging. Had to look at solution for help.

Spoiler

Spoiler:

Spoiler

Macro:

[MitchKibble]

Spoiler

[PeterGoldey]

lot of cobwebs on this one...

[arno_bürgin]

I used the find & replace tool. The provided solution is much simpler than mine.

[JonathanW]

This one was quite a head scratcher! 

I had to manually work through the logic iteration by iteration before converting it to a macro.

[andypick]

solution attached

Spoiler