Hi,

I have an Excel file which contains hundreds of user IDs, contact information, location, department, and manager IDs for each of listed users.

I need a script which reads the current Excel file, find/collect all users belonging to each of the managers, and then for each “manager” it creates new Excel files/sheets containing all users that belong to that manager.

Excel sheet:

 Code:
A	B	C	D
ID:	Unit:	Site:	Manager:
userP	UnitBX	London	ManD
userX	UnitA	Paris	ManA
user54	Unit34	London	ManF
user23	Unit34	London	ManF
user01	UnitRR	Paris	ManC
user11	UnitBX	Madrid	ManA
user7	UnitZ	Madrid	ManD
user62	UnitRR	London	ManD
userTX	UnitA	Paris	ManD
userLA	UnitFM	Madrid	ManA
user05	UnitRV	London	ManC
user12	UnitZ	Paris	ManC



Could someone give me a hand on this please?

BR/CY
_________________________
"... Great minds talk about idea' s, average minds talk about events and samll minds talks about people...!"