MICROSOFT EXCEL PRO PLEASE

[Autumn]

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

 

[Chip Pearson]

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

 

[Ron de Bruin]

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