I've got a database with a long list of names, and unique values associated with the names. What I want to do is create one worksheet for each individual, and then copy only their data to a specified range in their worksheet, then proceed to the next individual, copy their data to their worksheet etc.

This: http://tinyurl.com/mmhvmkz is a link to an example worksheet (in google docs form, note - I am actually using Excel 2010, not google docs).

I've been able to create all the worksheets through using the following code in a new sheet I called "Employee". All I did to this sheet was remove the duplicate name values so I could have a list of all the names for the worksheets.

Any help is much appreciated. Thanks in advance.

Please Login or Register  to view this content.