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.
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.