Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAGood macro practice! I also think this is completed challenge #100 for me. I'm slowly catching up to the Top Challengers.
My Solution. I used Binary operation in Iterative Macro. This challenge is fun.
elegant, lovely simple solution!
Awesome practice for Iterative Macro. Took me a morning to solve the problem.
Workflow
Macro
finally got over my fear of iterative and batch macros. I tried to do this as a batch macro but got weird results. Realized this is not a batch macro but an iterative macro. Still wish I could do it as a batch macro.... Did it two ways, once with a generate rows option and once with a created input file that I created in excel. Still wondering why the batch macro did not work......