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