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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!