Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThank you, @gawa! This was a tough one.
I leveraged the solution from @RolandSchubert with a single macro. Thank you both, @gawa and Roland, for sharing your expertise on this.
Workflow:
Macro:
Macro:
A quick edit to the solution I just submitted: you can convert 'Integer to Letter' input to a macro input - this way, you can update this reference table at anytime without having to modify the macro :)
Funny how sometimes you're trying to solve a work conundrum and a weekly challenge turns out to be exactly what you need!