Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI did my macro so that only one item could be selected at a time.
I did look at some other solutions for inspiration/help. I definitely need more practice on macros.
Macro:
Macro Interface:
I guess fiddling with spacing and punctuation is kind of the point of cleaning data for reporting.
My solution.
My macro is that can select the any field and add the prefix as 'Exchanged ' to exchanged field's name.
This challenge is good exercise for making more general working macro.