I think I got it right, if not please let me know how your data looks like and how it should look like after the code ran. But try this:
| A | B | C | D | E | F | G |
---|
Select Worker | | | | | | | |
Job | Lead | Lead$ | Worker1 | Worker1$ | Worker2 | Worker2$ | |
Sell Apples | John Doe | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Sell Apples | Jane Doe | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Clean Carpet | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Clean Carpet | Dude Bro | John Doe | Jane Doe | Dude Bro | Dude Bro | Dude Bro | |
Buy Cleaning Products | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Sell Watermelon | Jane Doe | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Load Trucks | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Clean Windows | Dude Bro | Dude Bro | Jane Doe | John Doe | Dude Bro | Dude Bro | |
Write reports | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Clean Windows | Jane Doe | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Sell Apples | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Sell Watermelon | Dude Bro | Dude Bro | John Doe | Dude Bro | Dude Bro | Dude Bro | |
Sell Watermelon | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Load Trucks | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Clean Carpet | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Jane Doe | |
Sell Apples | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Buy Cleaning Products | Dude Bro | Dude Bro | Dude Bro | Dude Bro | John Doe | Dude Bro | |
Unload Trucks | Dude Bro | Dude Bro | Dude Bro | Jane Doe | Dude Bro | Dude Bro | |
Sell Soda | Dude Bro | Dude Bro | Jane Doe | Dude Bro | Dude Bro | Dude Bro | |
Sell Soda | Dude Bro | John Doe | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Clean Windows | Jane Doe | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Unload Trucks | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | John Doe | |
Load Trucks | Dude Bro | Dude Bro | Jane Doe | Dude Bro | Dude Bro | Dude Bro | |
Sell Soda | Dude Bro | Dude Bro | Dude Bro | Jane Doe | Dude Bro | Dude Bro | |
Clean Carpet | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Jane Doe | Cool Guy | |
Buy Cleaning Products | Cool Guy | John Doe | Cool Guy | Jane Doe | Cool Guy | Cool Guy | |
Write reports | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Clean Carpet | Cool Guy | Cool Guy | Cool Guy | Jane Doe | Cool Guy | Cool Guy | |
Sell Apples | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Unload Trucks | Jane Doe | Cool Guy | Cool Guy | Jane Doe | Cool Guy | John Doe | |
Sell Watermelon | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Buy Cleaning Products | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Sell Apples | Cool Guy | Jane Doe | John Doe | Cool Guy | Cool Guy | Cool Guy | |
Clean Windows | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Clean Carpet | Jane Doe | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Load Trucks | Cool Guy | John Doe | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Write reports | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Sell Soda | Cool Guy | Cool Guy | Jane Doe | Cool Guy | Cool Guy | Cool Guy | |
Sell Watermelon | Cool Guy | Cool Guy | Cool Guy | John Doe | Cool Guy | Cool Guy | |
Unload Trucks | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Clean Windows | Cool Guy | John Doe | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Write reports | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Sell Watermelon | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Sell Soda | Cool Guy | Cool Guy | Jane Doe | Cool Guy | Cool Guy | Cool Guy | |
Unload Trucks | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | John Doe | |
Buy Cleaning Products | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Clean Windows | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Load Trucks | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Sell Soda | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Jane Doe | |
Write reports | John Doe | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]17[/TD]
[TD="align: center"]18[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]21[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]23[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]27[/TD]
[TD="align: center"]28[/TD]
[TD="align: center"]29[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]31[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]33[/TD]
[TD="align: center"]34[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]37[/TD]
[TD="align: center"]38[/TD]
[TD="align: center"]39[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]41[/TD]
[TD="align: center"]42[/TD]
[TD="align: center"]43[/TD]
[TD="align: center"]44[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]46[/TD]
[TD="align: center"]47[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]49[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]51[/TD]
[TD="align: center"]52[/TD]
</tbody>
| A | B | C | D | E | F | G |
---|
Select Worker | | | | | | | |
Job | Lead | Lead$ | Worker1 | Worker1$ | Worker2 | Worker2$ | |
Sell Apples | John Doe | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Clean Carpet | Dude Bro | John Doe | Jane Doe | Dude Bro | Dude Bro | Dude Bro | |
Clean Windows | Dude Bro | Dude Bro | Jane Doe | John Doe | Dude Bro | Dude Bro | |
Sell Watermelon | Dude Bro | Dude Bro | John Doe | Dude Bro | Dude Bro | Dude Bro | |
Buy Cleaning Products | Dude Bro | Dude Bro | Dude Bro | Dude Bro | John Doe | Dude Bro | |
Sell Soda | Dude Bro | John Doe | Dude Bro | Dude Bro | Dude Bro | Dude Bro | |
Unload Trucks | Dude Bro | Dude Bro | Dude Bro | Dude Bro | Dude Bro | John Doe | |
Buy Cleaning Products | Cool Guy | John Doe | Cool Guy | Jane Doe | Cool Guy | Cool Guy | |
Unload Trucks | Jane Doe | Cool Guy | Cool Guy | Jane Doe | Cool Guy | John Doe | |
Sell Apples | Cool Guy | Jane Doe | John Doe | Cool Guy | Cool Guy | Cool Guy | |
Load Trucks | Cool Guy | John Doe | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Sell Watermelon | Cool Guy | Cool Guy | Cool Guy | John Doe | Cool Guy | Cool Guy | |
Clean Windows | Cool Guy | John Doe | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
Unload Trucks | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | John Doe | |
Write reports | John Doe | Cool Guy | Cool Guy | Cool Guy | Cool Guy | Cool Guy | |
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]John Doe[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]19[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]28[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]35[/TD]
[TD="align: center"]38[/TD]
[TD="align: center"]41[/TD]
[TD="align: center"]43[/TD]
[TD="align: center"]47[/TD]
[TD="align: center"]52[/TD]
</tbody>
Using this code (You could assign the code to a button or to your Excel add ins)