Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Here's my solution.
Did not use a macro. Also did not see the Part II (wow!) until I posted this, but I added it in my own solution.
Kind of a brute-force approach.
Not the more efficient way to solve it...