Individual worksheet generation from list of names and data

Hi,

There is a list of names in column A with related data in remaining columns. The goal is to copy all data related to a given name, copy into a new worksheet, and give the worksheet the same name (doing this for multiple names and sets of data in the list). The list it's taken from will be different every time it's used but the format will be the same. So what I was planning on doing was finding the non blank cells in Column A, storing the value to name the sheet, copying all data until the next nonblank cell, and pasting that into a new sheet.

Side note: The list is copied from a pivot table that pulls data from another database. I am assuming that the method I'm attempting above is the best way to do this.

Here is an example of said dataset:
NPT Summary - HELP.xls

Here is what I have so far but it is nowhere close to working:

Please Login or Register  to view this content.

Hi K.J.Dub,
try it

Please Login or Register  to view this content.

Thank you nilem! that worked perfectly on my test sheet and will likely work perfectly on the other one. However, the names used are not in a format that is compatible with the sheet naming rules.

If I could add something to the code to modify each name it would work.. should I create another thread for that? The names have a / in them for example, "First Middle Last B-063-H/035-O-09" It would be acceptable for this workbook to just delete the "/035-O-09"

Please Login or Register  to view this content.