VBA help required: Creating multiple workbooks from a template and a list of names

Hopefully someone smarter than me can provide me with a neat VBA macro that will do the following;

The easiest way I can describe the scenario I am trying to create, is to use a company list of personnel (my index) and to generate a time-sheet workbook per person based on a pre-populated template. This time-sheet is saved as the persons name and has the persons name entered into cell D:10

I have a workbook which contains two worksheets;
1) An Index sheet which contains a list of names that I wish to use in Q16 downwards (note the length of this list will vary each time I run this)
2) A "template" sheet which I wish to duplicate in new workbooks
3) A second "data" sheet that I wish to copy across in new workbooks


I need a macro that will take the "template" and "data" sheets and copy it into a new workbook, renaming each new workbook to each name in my Index sheet. I also want that same Name to be copied into cell reference D:10 of the "template" each time.

The end result is that I should have a series of new files generated and saved which are named the same as the Index list, with both the "Template" sheet and the "Data" sheet present, with the cell D:10 pre-populated with the Name provided in the "Template" sheet.

For ease, I'll save these into My Documents for now. (If you need that info?)

I'm using Excel 2010, and have some knowledge of macros through using these forums for help, however I'm still a newbie so this one is making my head spin!

I hope that makes sense.

Hi..

The easiest way I can describe the scenario I am trying to create, is to

The easiest way is to click the "Go Advanced" button.. then click the 'Paper Clip' icon.. and attach a Sample Workbook..

Originally Posted by apo

Hi..



The easiest way is to click the "Go Advanced" button.. then click the 'Paper Clip' icon.. and attach a Sample Workbook..

Thanks for the constructive help I'm looking for help rather than sarcasm.

A sample workbook would not help as once I have stripped enough data out of the file to be able to upload to a public forum, I would have changed the sheet names and there would be no content.

Which part of the following statement was sarcastic..?

The easiest way is to click the "Go Advanced" button.. then click the 'Paper Clip' icon.. and attach a Sample Workbook..

A sample Workbook with some dummy data(content) added is the easiest way for others to help you without having to recreate the scenario themselves.

My advice to you was nothing but constructive (quite often people don't know how to attach a Workbook)..

Solved via another forum;

Please Login or Register  to view this content.