Greg
I would use VBA and loop through all the data in the information
workbook, for each loop place the data in the "Template", print the
Template, and repeat this for each record. Does this sound like what you
want? If so, post details about the layout of everything and what goes
where and what range do you want printed? HTH Otto
"Greg" wrote in message
...
I need to create an excel file that links to another excel file for the
information. The 1st file will be like a template that needs to print 1
record at a time, pulling that info from the 2nd excel file that will have
all the info. Do you know how to set this up? All I can seem to figure
out
is how to make the data connection but dont see how to put the data in the
darn document!