How to share data from one file to multiple files

Hi all,

I wanted to transfer Data from Master file to other multiple files.

Details :

I have master file with sheets A, B, C, D, E etc., In each of a sheets i have names listed along with number of tasks assigned.

I have files in same names, with same sheet names A, B, C, D ,E etc.,

Attached sample Master file and files for two names "Antony" and "Patric"

if i execute the macro in master file, it should open each of the files like "Antony", "Patric" etc., all the file that is available in the specific path folder
If the file name "Antony" is opened, then Data relevant to Antony from master file needs to be copy pasted in Antony file. The data should be transfered to relevant sheets From A to A, B to B etc., and save close.

Like wise, whatever the file is available in specific folder the data needs to be copy pasted from master file to relevant file.

could someone help me on this please.

Attached sample file.

Hi jindon,

Thanks for your response.

But this code is copying everything from master file to other files.

In the file "Antony", i dont want rest of the others data to reflect in Antony file.

In the file "Patric", i dont want rest of the others data to reflect in Patric file.

Can this be tweaked in here accordingly.... please.

Hi jindon,

Without any delay i should appreciate your effort on this.

The time you spent and you have really helped me.

Thanks for your help.