Data Segregation based on name criteria slide by slide in the selected sheet

[harinsh]

Hi Team,

I'm looking for the below requirement can anyone help on this...

Name	Date	Sales1	Sales2
Daniel	01/18/11	4,907.00	2,038.00
Daniel	12/23/11	3,527.00	2,985.00
Daniel	05/14/12	1,495.00	1,529.00
Daniel	09/12/12	4,527.00	2,777.00
Daniel	10/24/12	4,980.00	2,061.00
Johnson	09/17/10	3,713.00	2,939.00
Johnson	03/29/12	1,912.00	4,025.00
Johnson	10/21/12	1,170.00	3,631.00
Johnson	11/09/12	2,641.00	2,651.00
Johnson	01/01/13	1,829.00	3,998.00
Mary	09/20/10	1,614.00	3,668.00
Mary	07/20/11	2,303.00	4,939.00
Mary	01/06/12	2,103.00	1,701.00
Mary	03/04/12	2,003.00	3,570.00
Mary	06/06/12	2,925.00	2,608.00

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

Required output....

Name	Date	Sales1	Sales2		Name	Date	Sales1	Sales2		Name	Date	Sales1	Sales2
Daniel	01/18/11	4,907.00	2,038.00		Johnson	09/17/10	3,713.00	2,939.00		Mary	09/20/10	1,614.00	3,668.00
Daniel	12/23/11	3,527.00	2,985.00		Johnson	03/29/12	1,912.00	4,025.00		Mary	07/20/11	2,303.00	4,939.00
Daniel	05/14/12	1,495.00	1,529.00		Johnson	10/21/12	1,170.00	3,631.00		Mary	01/06/12	2,103.00	1,701.00
Daniel	09/12/12	4,527.00	2,777.00		Johnson	11/09/12	2,641.00	2,651.00		Mary	03/04/12	2,003.00	3,570.00
Daniel	10/24/12	4,980.00	2,061.00		Johnson	01/01/13	1,829.00	3,998.00		Mary	06/06/12	2,925.00	2,608.00

<colgroup><col><col><col span="2"><col><col><col><col span="2"><col><col><col><col span="2"></colgroup><tbody>
</tbody>

Need macro code to segregate the data...kindly do the needful.

Thanks,

 

[Jon von der Heyden]

Hi

Please stick with your original thread: http://www.mrexcel.com/forum/excel-questions/727479-data-segregation-based-name-criteria.html

I'm closing this one.