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 !!!
Hi @arsh011
Try this workflow
Hope this helps : )
Please find the workflow.
Can you share what these conditions look like.
For example each supplier has different horizon of report , some supplier need 12 months data, some need 18 months and some need 8 months in report but when I generate the files , the maximum number which is 18 months is applied for all supplier. How can I solve this problem.
Please help @atcodedog05 mate !!
@atcodedog05
Sorry, but i don't know how to solve this 😅