Maybe...

Debra Dalgleish shares a technique to use a worksheet as a database and then
populate another sheet with fields from that database--and then print it.

It may be possible to save that other worksheet as a new workbook instead of
printing.

http://contextures.com/xlForm03.html

Karen wrote:

Hi

is there a way to merge like a WORD mail merge whereby an excel listing is
merged to an excel template, thus into many files.

Thanks to advise!

--

Dave Peterson