Hi All,

I want to be able to copy an excel file from a specific location (chosen by the user), and paste it a number of times (user would input this number say in cell ref a1) and then it would be pasted in to another specific folder (chosen by the user).

Would it be possible to do this (if not the above is fine).... so it copies a file (chosen by user), but the amount of times to copy it depends on how many entries are in a specific column which is also used to rename the files.

So in column A it would bring up the file, Column B would show what file it is to be renamed to and then the last column would be the target where this file needs to be copied and pasted to.

The number of entries of the names would determine the amount of files copied.

Thank you