Hello! I have a problem with an excel sheet for work. Hope you can help!
I have to order employees by their entry time to work, and also by their role inside the company.
So, for example:
<tbody>
</tbody>
The role order is: Duty manager > Supervisor > Regular employee
So for this purpose I have use conditionals cell colors: Duty manager is RED, Supervisor is Green, Regular employee is Blue.
This way I can sort first colum A by color (RED>GREEN>BLUE), and then sort by entry time. The result would be:
<tbody>
</tbody>
I can do this easily with the regular sort and filter button. But I have to do it for all the days of the month, one at a time, for too many employees, and I lose so many time doing this.
I had try creating a macro for this, but it is driving me crazy. Please could you help me???
PD: Sorry for my english, hope you understand everything.
I have to order employees by their entry time to work, and also by their role inside the company.
So, for example:
Colum A | Colum B | Colum C | |
1 | Matt (regular employee) | 07:00 | 15:00 |
2 | Philip (supervisor) | 07:00 | 15:00 |
3 | Oscar (supervisor) | 08:00 | 16:00 |
4 | Jennifer (regular employee) | 09:00 | 17:00 |
5 | Ben (duty manager) | 08:00 | 16:00 |
<tbody>
</tbody>
The role order is: Duty manager > Supervisor > Regular employee
So for this purpose I have use conditionals cell colors: Duty manager is RED, Supervisor is Green, Regular employee is Blue.
This way I can sort first colum A by color (RED>GREEN>BLUE), and then sort by entry time. The result would be:
Colum A | Colum B | Colum C | |
1 | Ben (duty manager) | 08:00 | 16:00 |
2 | Philip (supervisor) | 07:00 | 15:00 |
3 | Oscar (supervisor) | 08:00 | 16:00 |
4 | Matt (regular employee) | 07:00 | 15:00 |
5 | Jennifer (regular employee) | 09:00 | 17:00 |
<tbody>
</tbody>
I can do this easily with the regular sort and filter button. But I have to do it for all the days of the month, one at a time, for too many employees, and I lose so many time doing this.
I had try creating a macro for this, but it is driving me crazy. Please could you help me???
PD: Sorry for my english, hope you understand everything.