creating new folder by Copying folder template and naming it with cell value

[DrMaghrabi]

Hello!

can someone help me in creating a code to perform the following: (NB. I don't Know coding)

I have an excel file contain a column with series no. (1,2,3,etc..) and a folder [named: Customers] contain folders named correspondingly but with leading zeros for the purpose of sorting thing as ( 0001, 0002, 0003, etc...)
I want when I add new number in the list [for ex: 52], it creates a new folder by copying the template Folder [new](in the folder: Customers) and its files content and name it [0052] and make the cell hyperlinked to this folder, so it opens the folder when I click on the number.

Thank you

 

[DrMaghrabi]

nope, it doesn't. Should the Macro check for existing hyperlinks and create if not present?

Yes that would be great
Thanks

 

[DrMaghrabi]

nope, it doesn't. Should the Macro check for existing hyperlinks and create if not present?

Ok, I did something resolved the problem.
I created new folder with the same name then ran the macro to create the files from the temp with hyperlinks. Then copied the original files to replace the created files.

Thank you very much for helping me.