maxblack
New Member
- Joined
- Nov 15, 2016
- Messages
- 36
Hello Collegues,
I need your help following idea. I have a table with employees where I insert, what they will be doing particular day. To make it more readable I have following idea:
When Perons 1 will choose her name, cells in row 2, where we have tasks, which have to done will be coloured. Which task should be coloured should be based on X inserted in row of that person. I try to figure it out how to do this using VBA.
I would be grateful for your support.
Thanks
max
<tbody>
</tbody>
I had no ide how to attach something.
I need your help following idea. I have a table with employees where I insert, what they will be doing particular day. To make it more readable I have following idea:
When Perons 1 will choose her name, cells in row 2, where we have tasks, which have to done will be coloured. Which task should be coloured should be based on X inserted in row of that person. I try to figure it out how to do this using VBA.
I would be grateful for your support.
Thanks
max
21/04/2017 | Task 1 | Task 2 | Task 3 | Task 4 | Task 5 | Task 6 | Task 7 | Task 8 | Task 9 | Task 10 | Task 11 | Task 12 | Task 13 | Task 14 | Task 15 |
P1 | X | ||||||||||||||
P2 | X | X | |||||||||||||
P3 | X | X | X | ||||||||||||
P4 | X | X | X | ||||||||||||
P5 | X | X | X | ||||||||||||
P6 | X | X | |||||||||||||
P7 | X | X | |||||||||||||
P8 | X | X | |||||||||||||
P9 | X | X | |||||||||||||
P10 | X | X | |||||||||||||
P11 | X | X | |||||||||||||
P12 | X | X |
<tbody>
</tbody>
I had no ide how to attach something.
Last edited: