IoanaStanescuNN
New member
Hi guys
I have a master file with details about salespersons.
The salespersons email addresses are not unique, so salesperson appears multiple times, with different signed contracts.
I need to create from this file, new excel files to share with every one of them, so they all receive just data about their own contracts.
The new files should keep the header and should be named using the salesperson email addresses.
Pls see some dummy data below.
So I need to get to smth like this, an excel for each email, named "[email protected]" in this case, with this format:
Do you think you can help me out here?
Thanks so much!
I have a master file with details about salespersons.
The salespersons email addresses are not unique, so salesperson appears multiple times, with different signed contracts.
I need to create from this file, new excel files to share with every one of them, so they all receive just data about their own contracts.
The new files should keep the header and should be named using the salesperson email addresses.
Pls see some dummy data below.
Agency | Unit_C | EmailAgent | Contract | Beneficiu | Client informat prin: | Maturitate | Revendicat |
Alba-Iulia | Alba Iulia Head Office | [email protected] | Voucher 400 lei analize barbati SanoPass | SMS | urmeaza maturitatea contractului | ||
Alba-Iulia | Alba Iulia Head Office | [email protected] | Voucher 400 lei analize hormonale SanoPass | Email+Notificare Push | urmeaza maturitatea contractului | ||
Alba-Iulia | Alba Iulia Head Office | [email protected] | Voucher 400 lei analize hormonale SanoPass | urmeaza maturitatea contractului | |||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Pachet „Energie si Vitalitate" RM | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize barbati SanoPass | Email+Notificare Push | |||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize barbati SanoPass | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize barbati SanoPass | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize hormonale SanoPass | Email+Notificare Push | |||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize hormonale SanoPass | Email+Notificare Push | |||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize hormonale SanoPass | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | Email+Notificare Push | |||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | Email+Notificare Push | |||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize barbati SanoPass | Email+Notificare Push | |||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | Email+Notificare Push | |||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | Email+Notificare Push | |||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | ||||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Voucher 400 lei analize vitamine SanoPass | urmeaza maturitatea contractului | |||
Alba-Iulia | Alba-Iulia Unit Ardeleanu | [email protected] | Pachet „Energie si Vitalitate" RM | SMS | |||
Alba-Iulia | Deva Unit Bohateret | [email protected] | Pachet analize “Vitalitate Masculina” RM | Email+Notificare Push | |||
Alba-Iulia | Deva Unit Bohateret | [email protected] | Pachet analize “Vitalitate Masculina” RM | Email+Notificare Push | |||
Alba-Iulia | Deva Unit Bohateret | [email protected] | Voucher 400 lei analize barbati SanoPass | Email+Notificare Push |
[td]
1
[/td][td]
2
[/td][td]
3
[/td][td]
4
[/td][td]
5
[/td][td]
6
[/td][td]
7
[/td][td]
8
[/td][td]
9
[/td][td]
10
[/td][td]
11
[/td][td]
12
[/td][td]
13
[/td][td]
14
[/td][td]
15
[/td][td]
16
[/td][td]
17
[/td][td]
18
[/td][td]
19
[/td][td]
20
[/td][td]
21
[/td][td]
22
[/td][td]
23
[/td][td]
24
[/td][td]
25
[/td][td]
26
[/td][td]
27
[/td]So I need to get to smth like this, an excel for each email, named "[email protected]" in this case, with this format:
Agency | Unit_C | EmailAgent | Contract | Beneficiu | Client informat prin: | Maturitate | Revendicat |
Alba-Iulia | Alba Iulia Head Office | [email protected] | Voucher 400 lei analize barbati SanoPass | SMS | urmeaza maturitatea contractului | ||
Alba-Iulia | Alba Iulia Head Office | [email protected] | Voucher 400 lei analize hormonale SanoPass | Email+Notificare Push | urmeaza maturitatea contractului | ||
Alba-Iulia | Alba Iulia Head Office | [email protected] | Voucher 400 lei analize hormonale SanoPass | urmeaza maturitatea contractului |
[td]
1
[/td][td]
2
[/td][td]
3
[/td]Do you think you can help me out here?
Thanks so much!