Hi Aleisha

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

I have mail code also on my site


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Aleisha Mollen" wrote in message
...
Hello. Every 3 months I have to run a report at work that lists all
employees, their title, department, and supervisor. I then have to separate
it into separate workbooks by supervisor and e-mail it out. I am looking for
an easier way to separate it into different workbooks by supervisor name.
Does anyone have any ideas on this? The report usually includes about 120
supervisors for 1800 employees. Thanks.