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

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


---
Regards,
Norman



"Stuart" wrote in message
ups.com...
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