Split One Work book into several based on content

In Column A I have Branch Code, Column B sales person, and C to G are
various sales types.

Can anyone point me to a macro which will take all the data for one branch,
and save it to a file called branchname.

The end result I'm looking for if I had 5 branches, would be 5 seperate file
each named by the individual branch name.

Rich

See
http://www.rondebruin.nl/copy5.htm

Try http://www.rondebruin.nl/copy5.htm#workbook

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Rich" <[email protected]> wrote in message news:[email protected]...
> In Column A I have Branch Code, Column B sales person, and C to G are various sales types.
>
> Can anyone point me to a macro which will take all the data for one branch, and save it to a file called branchname.
>
> The end result I'm looking for if I had 5 branches, would be 5 seperate file each named by the individual branch name.
>
> Rich
>

"Ron de Bruin" <[email protected]> wrote in message
news:[email protected]...
> See
> http://www.rondebruin.nl/copy5.htm
>
> Try http://www.rondebruin.nl/copy5.htm#workbook
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Rich" <[email protected]> wrote in message
> news:[email protected]...
>> In Column A I have Branch Code, Column B sales person, and C to G are
>> various sales types.
>>
>> Can anyone point me to a macro which will take all the data for one
>> branch, and save it to a file called branchname.
>>
>> The end result I'm looking for if I had 5 branches, would be 5 seperate
>> file each named by the individual branch name.
>>
>> Rich


Wow that's just about it.

I somehow think I'm going to be spending a lot of time on your site.

Thanks,

Rich