Hi there

I want a macro that can sort a spreadsheet into ascending order by
column A then look down the column and when it finds a change place
this into a new sheet with the name of the cell as the sheet name and
all other rows with the same name.

Essentially I want to break the spreadsheet into groups based on
column A,

A clear example

Name Number
John 1
Adam 2
John 1
Adam 3


I want the names grouped and then all the data moved to new sheets
called John and Adam.

Please let me know if you understand this,

Many thanks,

Stuart