List all employees overtime by working tasks

spilo

New Member
Joined
Jan 24, 2022
Messages
1
Office Version
  1. 2010
Platform
  1. Windows
Hi,
I'm sorry for my English!

I have a list of about 50 employees.
Usually, an employee can have different task and for each task he/she has a number of authorised overtime hours every month.
I have a worksheet with employee name and assigned tasks.
I was asked to create another worksheet to register the authorised overtime hours and the hours actually worked each month.
The user want to select the task and the month and then want to have the list of all employees assignet to that task in order to insert the authorised and worked hours.

What do you suggest I do?
I thought to create the Employee - tasks list with a two columns table having all the task in a cell separeted by commas. But I don't know how to create the dynamic list of employees when the user select the task.
Maybe some vba code is needed? Or is it possible to achieve that only with formulas ?

Thanks.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Create a unique all task table with duration other than regular working hours
Create unique employee list and use data validation list option to select the task
Based on above selection use vlookup to select the task that will give the duration apart from regular hours.
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,241
Members
452,622
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top