U
Uziel
Hi
I will appreciate any help.
I have this huge sheet, where I have the following columns:
A B C D E F G
Last name First Name Number Place Clinic Team Salesman
I need macro that will copy the rows (Including the headers row) of each
salesman to another file;call it by the name of the salesman (column G),
create a folder;call it by the name of the Team (Column F)
and save the file in that folder.
The file is sorted: first by Team and secondly by Salesman.
Salesman can be only in one team.
Thanks for your help.
Uziel
I will appreciate any help.
I have this huge sheet, where I have the following columns:
A B C D E F G
Last name First Name Number Place Clinic Team Salesman
I need macro that will copy the rows (Including the headers row) of each
salesman to another file;call it by the name of the salesman (column G),
create a folder;call it by the name of the Team (Column F)
and save the file in that folder.
The file is sorted: first by Team and secondly by Salesman.
Salesman can be only in one team.
Thanks for your help.
Uziel