Multiple instances of same process... must be a better way?

I seem to have a mental block about how to do this better? I frequently find myself filtering eg. a date column multiple times then feeding those multiple values into the same process which I've copy/pasted down the page:

This strikes me as being a 'not smart' way of going about things, but I can't get my head around how to improve this.

Surely I don't need to resort to macros (which I've not successfully used before)?

Any ideas would be much appreciated!

Thanks, Chris

Not smart.yxmd

Macros

Help

Preparation

Iterative Macro

Accepted answers

All comments

morr-co

Hi @CDunhill : it sounds like a batch macro may be useful? This would allow you to pass in the list of dates and the same operations are executed for each date in the list. Below is a link to a short video on how to build them.

https://youtu.be/YIAbQGQ_Hkg

mceleavey

Hi @CDunhill ,

I've attached the Workflow and the macro for you. I hope this helps.

Not smart.yxzp

Process X Macro.yxmc

CDunhill

Thank you - I will check this out. I'd kind of thought it might be possible sans macro, but seemingly not!

So, looks like time I got my head around batch macros! Thanks for the tutorial link, too.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703