populate from data from list values and save as seperate files

Hello,

I am trying to figure out how to perfrom the following action.

My challenge:

I need to create time sheets for about 30 contract workers.

Each time sheet needs to have their name as well the date for sunday of that week inserted into the form. (once the date for sunday is entered into the sheet, the rest of the dates for the week will be extrapolated out).

Then, once the data is inserted for a single worker, I need that file to be saved using the workers name in the file name.

The script would then open a new time sheet template, insert the second workers name and the date for sunday and save the file. Repeate for next 30 workers.

Is this type of action possible? If so how could I create it.

Any help would be greatly apperciated.

Thanks,

Frank

Perhaps something like this?

You will need to change the layout of the template sheet and at the moment the macro is set up to save the file in the location "D:\Temp\" a thing you also will need to change.

You fill in the workers name in the "Data" sheet starting at cell B3 and fill down as far as you need. Then you run macro "MakeFile" and macro loops through all
names in range B3 to B?? creating the files and (at the moment saving them to "D:\Temp\" folder).

Alf