Try this
http://www.rondebruin.nl/copy5.htm

Try the workbook example

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



<rich@richdavies.com> wrote in message news:1153389955.966884.4550@m73g2000cwd.googlegroups.com...
> Hi,
>
> I have a worksheet with all the sales data by salesperson for ten
> branches. Column A is Branch Name, B is Sales Person, C is sales
> figures.
>
> I want to create a macro which splits this into ten workbooks, named by
> branchname.
>
>
> Can anyone suggest the easiest way ?
>
>
>
> Rich
>