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.

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
(E-Mail Removed)
"J.W. Aldridge" <(E-Mail Removed)> wrote in message
news:102a1187-ab05-4473-b215-(E-Mail Removed)...
> 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.

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

--

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




"J.W. Aldridge" <(E-Mail Removed)> wrote in message
news:102a1187-ab05-4473-b215-(E-Mail Removed)...
> 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.

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