Excel Masters!!
So I have an excel workbook that I am developing to track how much our labor cost is for how much material is shipped each day. I am pulling in data for employee hours worked each day (into "Morning Report Simplified" sheet), then manually pulling the information from range P4:33 on the "Morning Report Simplified" sheet and inputting that information into the "Employee Hours" sheet for that respective day's row.
The issue:
I am sure there is a way to automate this process. At first I was thinking a simple reference, however I am updating the information on the "Morning Report Simplified" sheet everyday so the information on the "Employee Hours" sheet would keep overwriting itself. The only way I can think of to make this work is to use some sort of time stamp for when I update the raw data in the "Morning Report Simplified" and updating the corresponding rows information for that day in the "Employee Hours" sheet. So to say the cells are told, "ok you have yesterdays information, tomorrow I am going to pull in the new data and not delete any other previous days information". Sorry this is my weird way of thinking for what I want the cells to be doing lol.
Anyway any help or direction in this matter will be greatly appreciated.
- DasBurgers
CostperKilo_3.xlsx
Bookmarks