Hello!

I have a workbook with two worksheets: alpha and beta.

In alpha I have a list of names in column D. The list of names can vary
and I have the total number of names in cell B2 (counta(D:D)).

In beta I have a questionaire.

Now I'd like to have a macro that saves the worksheet beta only but
multiple times. Each beta worksheet should be saved as an excel file
with the name comming from the namelist in alpha/column D. The saving
should be finished once beta is saved under each name.

Example 1:
alpha contains in column D: john, paul, jerry
then beta alone should be saved as john.xls, paul.xls and jerry.xls

Example 2:
alpha contains in column D: john, richard, tim, edmund, mark
then beta alone should be saved as john.xls, richard.xls, tim.xls,
edmund.xls and mark.xls

Hope somebody can help me cause I have no clue with macros (yet).

Thanks
Marc Baumann