Creating Seperate From Master Worksheet

[will2learn]

I have a file with a master worksheet from which I would like to automatically create seperate files for each customer.

Cells A10:AF10 contain the column headers, the customers are all listed in cells E11:E23098.

Is it possible to automatically create an individual file for each customer containing only their own records?

 

[HalfAce]

Cells A10:AF10 contain the column headers, the customers are all listed in cells E11:E23098.
Is it possible to automatically create an individual file for each customer containing only their own records?

Do I understand you correctly? You want to create 23,087 separate workbooks?

 

[Charlie45]

See if this thread helps:

http://www.mrexcel.com/forum/showthread.php?t=330428&highlight=create+multiple+sheets