create a list of single values from multiple values
 

I have a list:

Name Number Date
Ann 13 10/24/2005
Cindy 3 10/14/2005
Jordan 19 10/30/2005
Jordan 20 10/31/2005
Cindy 6 10/17/2005
Cindy 2 10/13/2005
Jordan 18 10/29/2005


From this I need to create a seperate list in seperate worksheets for each
unique value in column A.

For example:
Ann 13 10/24/2005

Cindy 3 10/14/2005
Cindy 6 10/17/2005
Cindy 2 10/13/2005

Jordan 18 10/29/2005
Jordan 19 10/30/2005
Jordan 20 10/31/2005

Any help will be appreciated.

Jordan

create a list of single values from multiple values
 

Sort all the data by the first column. Then copy rows with the same value in
the first column into separate worksheets.
--
Gary''s Student


"Jordan" wrote:

I have a list:

Name Number Date
Ann 13 10/24/2005
Cindy 3 10/14/2005
Jordan 19 10/30/2005
Jordan 20 10/31/2005
Cindy 6 10/17/2005
Cindy 2 10/13/2005
Jordan 18 10/29/2005


From this I need to create a seperate list in seperate worksheets for each
unique value in column A.

For example:
Ann 13 10/24/2005

Cindy 3 10/14/2005
Cindy 6 10/17/2005
Cindy 2 10/13/2005

Jordan 18 10/29/2005
Jordan 19 10/30/2005
Jordan 20 10/31/2005

Any help will be appreciated.

Jordan

create a list of single values from multiple values
 

Sort them coloumn A then by coloumn B and so on...

Nimit Mehta

"Jordan" wrote:

I have a list:

Name Number Date
Ann 13 10/24/2005
Cindy 3 10/14/2005
Jordan 19 10/30/2005
Jordan 20 10/31/2005
Cindy 6 10/17/2005
Cindy 2 10/13/2005
Jordan 18 10/29/2005


From this I need to create a seperate list in seperate worksheets for each
unique value in column A.

For example:
Ann 13 10/24/2005

Cindy 3 10/14/2005
Cindy 6 10/17/2005
Cindy 2 10/13/2005

Jordan 18 10/29/2005
Jordan 19 10/30/2005
Jordan 20 10/31/2005

Any help will be appreciated.

Jordan

create a list of single values from multiple values
 

Hi Jordan

Try this macro solution
http://www.rondebruin.nl/copy5.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jordan" wrote in message ...
I have a list:

Name Number Date
Ann 13 10/24/2005
Cindy 3 10/14/2005
Jordan 19 10/30/2005
Jordan 20 10/31/2005
Cindy 6 10/17/2005
Cindy 2 10/13/2005
Jordan 18 10/29/2005


From this I need to create a seperate list in seperate worksheets for each
unique value in column A.

For example:
Ann 13 10/24/2005

Cindy 3 10/14/2005
Cindy 6 10/17/2005
Cindy 2 10/13/2005

Jordan 18 10/29/2005
Jordan 19 10/30/2005
Jordan 20 10/31/2005

Any help will be appreciated.

Jordan