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