I have an attendance sheet that I need to copy for 400 employees. I have linked it to database that I imported and filtered. I am only extracting name, id, fte and hire date. On my timesheet tab I am copying and pasting a new sheet for each employee, but when I copy a new sheet, the formula updates by linking to the new position based on copied/pasted line, instead I want a formula to pick up next employee and each one after. See attached (i.e., look in formula bar on the record I'ved copied, and see how it reads ='Employee List'!$F51, instead I need it to pick up ='Employee List'!F3, then on the next copied timesheet, ='Employee List'!F4. But instead it grabs whatever line I start on. What is a way to do this? Also is there an easier way than copying 400 employee timesheets (every 50 lines), than what I'm doing?
66.5 KB Views: 33