Macro for creating separate files with fixed password from colum

Closed
Report
Posts
2
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 17, 2017
-
Posts
2
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 17, 2017
-
Hi All,

I need urgent help for a macro which will create separate files from a column value

I have this data in the picture attached
http://static.ccm2.net/ccm.net/pictures/if1pma3Hps7YPUlRcTPE1EqT55I2RzepojcYCyIrcD0EJu8SQpNvaCBzCNtcju0Y-excel.png
Now the data is segregated to four day sheets named "5 to 9 days", "10 to 14 days", "15 to 29 days" and "30 days and above" as per the Column F (Days Remaining).
http://static.ccm2.net/ccm.net/pictures/dNWCETjgIgiA4ji9075Cm6XBU06HVQWzm1IBV54vgHva7YvJJI66hXtAraPbUAu1-excel2.png
The macro should create separate files as per the Country (Column E) for each of the day sheets separately.
Note: *The first four rows should be same for all the files.
  • The file's name should be the Country code_Cash, for e.g. "USA_Cash"
  • The pasword should be "abcd" for all the files.
  • The files should be saved in 4 different folders named as "5 to 9 days", "10 to 14 days", "15 to 29 days" and "30 days and above" in the location where the master file exists.

Please get back for any details/clarifications.

Thanks in advance for your help.

1 reply

Posts
2
Registration date
Wednesday July 5, 2017
Status
Member
Last seen
July 17, 2017

Hi Friends,

Can anybody please help me on this?

Your help is much appreciated.

Thanks.