create sheets based on data in string and copy to
 

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.

create sheets based on data in string and copy to
 

Wouldn't it be better to keep it all on ONE sheet and use filters, etc to
get info?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"J.W. Aldridge" wrote in message
...
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.

create sheets based on data in string and copy to
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"J.W. Aldridge" wrote in message
...
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.

create sheets based on data in string and copy to
 

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