Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI added a bit to this, where if you so desired you can have the workflow continue to change the ranges that it's checking for as time goes on. That way, when we are running this next month, we don't have to add any parameters to our text input table.
Great for batch macro practice.
A bit messy, but gets the job done...
This one broke me - I think it would have been a lot easier if the rules were bulleted at the start i.e. if closed before then can't be open in the future etc.
Ended up using an iterative macro. All done anyway 🙂