Split rows into multiple sheet if.....

[Stuart]

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

 

[Norman Jones]

Hi Stuart,

See Ron de Bruin's sample code at:

Create a new sheet for all Unique values
http://www.rondebruin.nl/copy5.htm#all