create sheets based on data in string and copy to

[J.W. Aldridge]

data in columns a:f


Need to create new sheets for each unique name in column c.
Then copy all rows (except header in row1) for each unique name to its
unique sheet starting at a11.
If sheet exist, keep adding it to the next available row.

 

[Don Guillett]

Wouldn't it be better to keep it all on ONE sheet and use filters, etc to
get info?

 

[Ron de Bruin]

See
http://www.rondebruin.nl/copy5.htm

 

[J.W. Aldridge]

na Don, I needed individual sheets.
Using Ron's code....