How to create a macro for writing Excel files for different suppliers

[arsh011]

I want write Excel files grouped by on Suppliers on their certain conditions according to their data.. How I can do this through macro or some kind of loop so that each file will be generate according to each supplier conditions. Please Help !!!

[arsh011]

@atcodedog05 

macro file is missing please attach that also , thanks mate!!

[atcodedog05 · Accepted solution]

Hi @arsh011 

Please find the workflow.

Hope this helps : )

[arsh011]

Thanks a lot @atcodedog05, it really helps but can we include years also with the month and after December it shows numbers, instead of numbers it should include months with next year.