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

Split One Work book into several based on content
 

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

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

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


"Rich" wrote in message ...
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

Split One Work book into several based on content
 

"Ron de Bruin" wrote in message
...
See
http://www.rondebruin.nl/copy5.htm

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

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


"Rich" wrote in message
...
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