I have 2 Excel sheets. One sheet is titled TIMESHEET and the other EMPLOYEES. On the TIMESHEET I have one cell for a persons full name and another for the position worked. On the EMPLOYEE sheet I have 2 columns, one titles FULL NAME and the other POSITION. Let's assume I have a list of 10 employees. I would like to produce 10 copies of the TIMESHEET with the proper names and positions of each employee on each individual sheet.
I assume this is a simple task, but the solution has evaded me. Any help would be appreciated.
Maurice
Bookmarks