On worksheet1 I have a an attendance calender with blank spots for NAME, DEPARTMENT, DATE of HIRE. On worksheet2 I have a list of employees, departments, and hire dates. I want Excel to print off the attendance calendar for each employee in list on worksheet2. (example 200 employees...for every name in the list on worksheet2, insert name, dept., DOH, into worksheet 1) How and what formula do I use????