Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAWhat a sophisticated challenge!
I approached this two ways. Built it first as just a workflow and full disclosure, I did look through solutions since I'm just starting to dig deep into macros. I stepped through and built it based on what I saw in other's solutions, just so I could grasp the proper settings. Great learning experience and I look forward to more as I work through the Weekly Challenge list!
At first I tried to solve it without a macro, but it did not work for me. Then, when consulting the solution posted, I liked the idea that the solution was built using an iterative macro. I was then able, after understanding the approach, to build one on my own iterative macro, yay!