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 !!!

[atcodedog05]

Hi @arsh011 

Can you share what these conditions look like.

[arsh011]

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.

[arsh011]

Please help @atcodedog05  mate !!

:(

[arsh011]

@atcodedog05 

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.

[atcodedog05]

Hi @arsh011 

Sorry, but i don't know how to solve this 😅

[arsh011]

@atcodedog05 

Some kind of macro would work , that takes 1 supplier according to their condition and generate file one by one for each supplier?

[atcodedog05]

Hi @arsh011 

Can you provide some sample data.

[arsh011]

@atcodedog05 

SHEET 1 SAMPLE DATA 

SHEET 2 AND SHEET 3 DESIRED FILES AS PER SUPPLIER.

[atcodedog05 · Accepted solution]

Hi @arsh011 

Try this workflow

Hope this helps : )