Hello!
I am trying to simplify my weekly time sheets and cost codes as well as stream line that information to my budget (the budget is not included in this question). In the attached workbook, I have 3 sheets. Sheet John_Smith_Daily is where I would put one employee's daily time into the correct cost code category. John_Smith_Timesheet_BLANK is what my weekly timesheet looks like before any data and John_Smeeth_Timesheet is what I would like for it to look like when all of the data is filled in. Now on to my question:
I would like to enter a formula into John_Smith_Timesheet that would parse John_Smith_Daily and add all hours worked and cost codes for a given day. I do not want to include cost codes that have empty cells. Is this possible? My John_Smith_Timesheet is somewhat dynamic considering all I have to do is enter the week ending date and it fills in the dates for the week for me. I would ultimately like to enter any date and the worksheet would fill in the cost codes and times accordingly.
Thanks!
Bookmarks