Nitin Panjwani
New Member
I have attached a copy of data where I need multiple workbooks created based on column A named “Country Sales Office”
Based on the countries named in this column, the macro should create multiple workbooks with their respective names and the month name which will be dynamic (changing every month).
I have tried making a macro with some coding, but it screws up the data. I mean it gives data for some other country in some other country. (Some coding issue as it was built by a colleague who has now left the company)
If anyone could help, it would be helpful and valuable. Hope I am clear in explaining my problem. Feel free to reach out.
Based on the countries named in this column, the macro should create multiple workbooks with their respective names and the month name which will be dynamic (changing every month).
I have tried making a macro with some coding, but it screws up the data. I mean it gives data for some other country in some other country. (Some coding issue as it was built by a colleague who has now left the company)
If anyone could help, it would be helpful and valuable. Hope I am clear in explaining my problem. Feel free to reach out.