I have a workbook, which so far has three sheets. Sheets 2 and 3 are to be
used to track employee hours worked and what their pay is. One sheet per
employee. The columns from left to right indicate the date, start time, stop
time, time taken for lunch, hours worked for that day, and pay for that day
based on a constant rate of pay. I've divided up the year into weeks, with
the year beginning January 1 and ending December 31, each week begins with
Sunday and ends with Saturday with the exception being the first day of the
year and the last day of the year. At the bottom of each week, for the hours
worked column and the pay column, are cells summing up the totals in each
category for the week. I want the first sheet to be a summary sheet showing
for each employee, the hours worked per month and the pay earned per month.
The months will track Jan thru Dec across the sheet with a column for hours
and pay under each month. The employees will be listed in column A one above
the other. How do I do this? Any help greatly appreciated. Thank you.