I'm close.. but a couple of questions...
If i move the "name" field to the A column and hightlight the names, it creates the time cards... but it removes the word "Department" if front of what is inserted.... and saves the all the files to My Documents folder... I can live with it but I would like the word Department to stay and for the files to be saved in the same folder as the timecard blank and name list... thanks for your help...DRG