Creating workbooks from data in work book

hi,
i have a woork book with a list of names and numbers
for ex:
Jhon B 123
Katy C 45
Tom vxc 78

and i want to create a vba function that will create a new work book for each name:
Jhon B.xls
Katy C.xls
Tom vxc.xls
and that each one of them will be with template and that the function will insert the name and the number to two predefined cells?

i cant figure how to do this..
(i know that theoritcly i need a while loop that will go trough all the rows and for each will create a file with the data from the first column,but dont know how to input inside the file that have to be with template)

Thanks Alot!!!
i've come only with this:

Please Login or Register  to view this content.

but your's seems much better and exactly what i needed

Hi,
The Example that Domski posted is almost what I need as well, but I can't quite work out how to modify it to achieve the results I need. (VBA is not a strong point of mine).
So in addition to creating individual workbooks with names derived from a master workbook, I need it to create additional worksheets per workbook (from the template), and write a couple bits of information in each generated work sheet. I have attached an example. So the result will be: The number of Workbooks depending on the number of "Save Worksbook Name"s, each with having 4 Worksheets (Template1, Template2, Template3, Template4), with each Template worksheet having the 2 beits of info written to it ("Name" & "Company").

The assistance will be much appreciated!!!

Cheers!

Brad