NatureGreen
New Member
- Joined
- Mar 12, 2019
- Messages
- 7
Hi all
Every week i get a new report with over 600 employees.
Each of them are asigned to a coach. (Column I)
I have to select them and make a new worksheet per coach.
So that every coach has a clear list.
How can i automate this so that i can put the report on sheet 1 and that it automatically makes a new sheet for every coach?
Idk how i can add a better example but it's something like this but with more columns.
So it's based on the column Coach and the amount of employees can shift alot.
<colgroup><col style="mso-width-source:userset;mso-width-alt:3072;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2141;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:3025;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:2466;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2327;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:3211;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:2048;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:2420;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:2536;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:2350;width:51pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:3025;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:2769;width:60pt" width="79"> </colgroup><tbody>
</tbody>
Thanks in advance.
Every week i get a new report with over 600 employees.
Each of them are asigned to a coach. (Column I)
I have to select them and make a new worksheet per coach.
So that every coach has a clear list.
How can i automate this so that i can put the report on sheet 1 and that it automatically makes a new sheet for every coach?
Idk how i can add a better example but it's something like this but with more columns.
So it's based on the column Coach and the amount of employees can shift alot.
Employer | type | company | Group | place | id location | unit | Adres | Coach | name | firstname | Work ID |
JOBA | fulltime | Place A | dlfkjmsdfj | dlfjiel | 108080 | Zone B | Street | John | Person 1 | Firstname 1 | 1563050580 |
JOBB | Parttime | Place B | dmfkd | dlfkjmsdfj | 108080 | Zone A | Lane | John | Person 2 | Firstname 2 | 1562885584 |
JOBB | fulltime | Place D | fmdjfoe | dmfkd | 15568 | Zone D | Drive | Josy | Person 3 | Firstname 3 | 1562907624 |
JOBA | Parttime | Place A | dfjldkjfl | fmdjfoe | 43984 | Zone C | Road | Jenny | Person 4 | Firstname 4 | 1562989780 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3072;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2141;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:3025;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:2466;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2327;width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:3211;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:2048;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:2420;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:2536;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:2350;width:51pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:3025;width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:2769;width:60pt" width="79"> </colgroup><tbody>
</tbody>
Thanks in advance.