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!!