I hope this can be handled without VBA coding (I dont know VBA at all) but I would appreciate any help I can get. I have two worksheets labeled 'Labor Hrs' and 'Time Summaries'. On the sheet 'Labor Hrs' I enter start and end times for an employee. It returns the regular hours, Overtime and Double time hours in the ranges J7:J37, K7:K37, and L7:L37 respectively. Each row (7 through 37) is for a particular day of the month. I don’t want to have a different copy of this worksheet for each of the company’s 50 employees so I was hoping to make a macro (button) that would transfer the values in the range (J7:L37) to a named ranged in the worksheet 'Time Summaries' into the array column defined by the value in 'Labor Hrs'!N1. The named range is labeled “Workertimes” and it refers to 'Time Summaries'!C5:EV35. I would specifically like it to transfer the values in J7:J37 to the array column number (value in N1), K7:K37 into the array column number N1+1, and L7:L37 into the array column number N1+2. Then save the values there and clear the entry cells in the 'Labor Hrs' worksheet to allow for the next employee to be selected and hrs to be entered.
So if N1=1, pressing the button should do the following:
1. Copy and paste all the values in 'Labor Hrs'!J7:J37 into column 1 of the named range “Workertimes”.
2. Copy and paste the values in 'Labor Hrs'!K7:K37 into column 1+1=2.
3. Copy and paste the values in 'Labor Hrs'!L7:L37 into column 1+2=3.
4. Clear the 'Labor Hrs' entry cells (without clearing the newly pasted data in the "Workertimes" array.)
5. Set cell A1 in “Labor Hrs” worksheet as the active cell.

I would appreciate the help.