software

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
www.rondebruin.nl/copy5.htm

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

--
Regards Ron de Bruin
www.rondebruin.nlquot;Richquot; gt; wrote in message ...
gt; In Column A I have Branch Code, Column B sales person, and C to G are various sales types.
gt;
gt; Can anyone point me to a macro which will take all the data for one branch, and save it to a file called branchname.
gt;
gt; The end result I'm looking for if I had 5 branches, would be 5 seperate file each named by the individual branch name.
gt;
gt; Rich
gt;

quot;Ron de Bruinquot; gt; wrote in message
...
gt; See
gt; www.rondebruin.nl/copy5.htm
gt;
gt; Try www.rondebruin.nl/copy5.htm#workbook
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Richquot; gt; wrote in message
gt; ...
gt;gt; In Column A I have Branch Code, Column B sales person, and C to G are
gt;gt; various sales types.
gt;gt;
gt;gt; Can anyone point me to a macro which will take all the data for one
gt;gt; branch, and save it to a file called branchname.
gt;gt;
gt;gt; The end result I'm looking for if I had 5 branches, would be 5 seperate
gt;gt; file each named by the individual branch name.
gt;gt;
gt;gt; RichWow that's just about it.

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

Thanks,

Rich