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

Without code you can use EasyFilter
http://www.rondebruin.nl/easyfilter.htm

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


"erinnicole782" wrote in message
news:erinnicole782.265nro_1144851903.7037@excelfor um-nospam.com...

I have one workbook attached that has a listing of all my supervisors
and their direct reports, I also have attached a blank workbook. I
basically need to take each supervisor and all the information about
their direct reports and send it over to the blank workbook.

The end result would be a seperate workbook for each supervisor.

This is really hard to explain: this is how i have been doing it
manually
In the Main workbook (list all supervisors)

Step 1- Pick a supervisor
Step 2- delete all others
Step 3- File save as Lastname.Firstname
Step 4-close the workbook
Step 5-reopen the main Workbook
Step 6- select the next supervisor

then repete steps 2-6 until a seperate workbook has been created for
each supervisor

I am just looking to write a macro that automates this process, its far
to tedious to do it manually.

Please if ther is anybody who can help, please help....i need it:(


+-------------------------------------------------------------------+
|Filename: Excel Test.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4620 |
+-------------------------------------------------------------------+

--
erinnicole782
------------------------------------------------------------------------
erinnicole782's Profile: http://www.excelforum.com/member.php...o&userid=33406
View this thread: http://www.excelforum.com/showthread...hreadid=532296