Hi excellers!
And once again, i require your help. Thank you in advance for brainstorming and always providing such awesome solutions.
Here is another "puzzle" that i need to solve and require all the help you can render.
I have a workbook that has several worksheets.
Each worksheet has exactly the same format and exactly the same cells ranges.
Worksheets have rows with peoples names and columns with data validation, which are filled up by the users by choosing values from the drop down menus.
Now, the worksheets are for each working day of the month and vary from months to month: obviously the. names in the following format DD.MM.YYYY and the quantity of the sheets.
They are created manually for each month, excluding holidays and days off.
What i need to do:
At the end of each month when the workbook is all filled up i add one more worksheet - to calculate statistics.
Rows are the same like in the "daily" sheets, however, rows are for each day/week and at the end of the rows - totals for each person for the whole working month.
Each time in exactly this format, however the number of columns is different for each month (different working days, different number of weeks, etc).
I will usually do it manually at the end of each month.
What i want: I'd like to have a code that helps calculating values for each person from all the daily sheets.
I can paste this code each time manually when i create the statistics worksheet with some adjustments for each month.
Example of the daily sheet:
I need to know how much each person worked from home or from home office and what time of the day more of which.
Is there a way to make me work now so that i dont have to die every end of the month with this?
Thank you for saving private Vikosh
PS. color coding: yellow - home office/brown - training / different colours - each period of a day
And once again, i require your help. Thank you in advance for brainstorming and always providing such awesome solutions.
Here is another "puzzle" that i need to solve and require all the help you can render.
I have a workbook that has several worksheets.
Each worksheet has exactly the same format and exactly the same cells ranges.
Worksheets have rows with peoples names and columns with data validation, which are filled up by the users by choosing values from the drop down menus.
Now, the worksheets are for each working day of the month and vary from months to month: obviously the. names in the following format DD.MM.YYYY and the quantity of the sheets.
They are created manually for each month, excluding holidays and days off.
What i need to do:
At the end of each month when the workbook is all filled up i add one more worksheet - to calculate statistics.
Rows are the same like in the "daily" sheets, however, rows are for each day/week and at the end of the rows - totals for each person for the whole working month.
Each time in exactly this format, however the number of columns is different for each month (different working days, different number of weeks, etc).
I will usually do it manually at the end of each month.
What i want: I'd like to have a code that helps calculating values for each person from all the daily sheets.
I can paste this code each time manually when i create the statistics worksheet with some adjustments for each month.
Example of the daily sheet:
I need to know how much each person worked from home or from home office and what time of the day more of which.
Is there a way to make me work now so that i dont have to die every end of the month with this?
Thank you for saving private Vikosh
PS. color coding: yellow - home office/brown - training / different colours - each period of a day
