New worksheet for every name

[Gemandshed]

Hi

I think it’s a VBA I need
I’ve got a spreadsheet with a list of names and data
I want a new worksheet for every change in name
(Most people have more than 1 line)
But the top line (headers) need to be at the top of everyone’s worksheet
The worksheet name needs to be the persons name (column A)

Thank you in advance

 

[MARK858]

I’ve got a spreadsheet with a list of names and data

What is the name of the worksheet?

But the top line (headers) need to be at the top of everyone’s worksheet

What is the last used column?

 

[MARK858]

The worksheet name needs to be the persons name (column A)

Are the names in blocks?

 

[Gemandshed]

Thanks Mark. I found some issues with my spreadsheet and then managed to find the VBA I was looking for.
Thanks for your responses.