Maybe this will help you then if you data is organized correct
http://www.rondebruin.nl/copy5.htm


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


"Chip Pearson" wrote in message ...
I think you need to better describe how the data is organized on the main sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Autumn" wrote in message ...
I have an Excel Worksheet that has employee data and customer relationships.
Each employee has several customers. I need to create one spreadsheet (tab
within the workbook) per employee that incorporates all of their customers.
Is their an automated way to do this??

HELP!!