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