Split One Work book into several based on content

[Rich]

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]

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

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

 

[Rich]

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

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

Wow that's just about it.

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

Thanks,

Rich