Macro for creating new sheets based on unique values in a row...

I've searched the web and found numerous similar examples to what I want, but I can't quite get them to work the way I want.

I have approximately 20 sheets, each with a list of names in a row, with corresponding data for each name. I want to run a macro on each sheet to create a new sheet for each name and copy the corresponding row to that sheet. Then I want to run the macro on my next master sheet, and copy the rows associated with those names to the previously created 'name sheets' that were created, placing the new row of data directly under the previous data that was moved. So on and so forth, for each of my 20 sheets.

Hopefully that makes sense. Any help is greatly appreciated!

Are these 20 sheets what you call master sheets?
How are they named?
Could it be that the list of names are in a column, not in a row? (copy the corresponding row etc etc)
Is there a chance that there are different or new names in any of the 19 sheets after you worked on the first "master" sheet?

Are these 20 sheets what you call master sheets?
How are they named?
Could it be that the list of names are in a column, not in a row? (copy the corresponding row etc etc)
Is there a chance that there are different or new names in any of the 19 sheets after you worked on the first "master" sheet?

I apologize, I misexplained.

Yes, the 20 sheets are 'master sheets' if you will. They are actually sheets for different years, so I have one for each year, going back 20 years.

The names are listed in column A, going down rows (approximately 150). So I want to create a new sheet for each name (so ~150 new sheets).

Hopefully that makes more sense.

Try this on a copy of your workbook.

Please Login or Register  to view this content.

Thanks for the help.

I get an error when I run that code: Run time error code 13, type mismatch.

The line of code highlighted is:

If Not Evaluate("ISREF('" & c.Value & "'!" & c.Address & ")") Then

Use a function instead to check if the sheets exist.

Please Login or Register  to view this content.

Please Login or Register  to view this content.