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...

[TABLE="width: 263"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Sales1[/TD]
[TD]Sales2[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD="align: right"]01/18/11[/TD]
[TD] 4,907.00[/TD]
[TD] 2,038.00[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD="align: right"]12/23/11[/TD]
[TD] 3,527.00[/TD]
[TD] 2,985.00[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD="align: right"]05/14/12[/TD]
[TD] 1,495.00[/TD]
[TD] 1,529.00[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD="align: right"]09/12/12[/TD]
[TD] 4,527.00[/TD]
[TD] 2,777.00[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD="align: right"]10/24/12[/TD]
[TD] 4,980.00[/TD]
[TD] 2,061.00[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[TD="align: right"]09/17/10[/TD]
[TD] 3,713.00[/TD]
[TD] 2,939.00[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[TD="align: right"]03/29/12[/TD]
[TD] 1,912.00[/TD]
[TD] 4,025.00[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[TD="align: right"]10/21/12[/TD]
[TD] 1,170.00[/TD]
[TD] 3,631.00[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[TD="align: right"]11/09/12[/TD]
[TD] 2,641.00[/TD]
[TD] 2,651.00[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[TD="align: right"]01/01/13[/TD]
[TD] 1,829.00[/TD]
[TD] 3,998.00[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD="align: right"]09/20/10[/TD]
[TD] 1,614.00[/TD]
[TD] 3,668.00[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD="align: right"]07/20/11[/TD]
[TD] 2,303.00[/TD]
[TD] 4,939.00[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD="align: right"]01/06/12[/TD]
[TD] 2,103.00[/TD]
[TD] 1,701.00[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD="align: right"]03/04/12[/TD]
[TD] 2,003.00[/TD]
[TD] 3,570.00[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD="align: right"]06/06/12[/TD]
[TD] 2,925.00[/TD]
[TD] 2,608.00
[/TD]
[/TR]
</tbody>[/TABLE]

Required output....
[TABLE="width: 903"]
<colgroup><col><col><col span="2"><col><col><col><col span="2"><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Sales1[/TD]
[TD]Sales2[/TD]
[TD][/TD]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Sales1[/TD]
[TD]Sales2[/TD]
[TD][/TD]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Sales1[/TD]
[TD]Sales2[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD="align: right"]01/18/11[/TD]
[TD] 4,907.00[/TD]
[TD] 2,038.00[/TD]
[TD][/TD]
[TD]Johnson[/TD]
[TD="align: right"]09/17/10[/TD]
[TD] 3,713.00[/TD]
[TD] 2,939.00[/TD]
[TD][/TD]
[TD]Mary[/TD]
[TD="align: right"]09/20/10[/TD]
[TD] 1,614.00[/TD]
[TD] 3,668.00[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD="align: right"]12/23/11[/TD]
[TD] 3,527.00[/TD]
[TD] 2,985.00[/TD]
[TD][/TD]
[TD]Johnson[/TD]
[TD="align: right"]03/29/12[/TD]
[TD] 1,912.00[/TD]
[TD] 4,025.00[/TD]
[TD][/TD]
[TD]Mary[/TD]
[TD="align: right"]07/20/11[/TD]
[TD] 2,303.00[/TD]
[TD] 4,939.00[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD="align: right"]05/14/12[/TD]
[TD] 1,495.00[/TD]
[TD] 1,529.00[/TD]
[TD][/TD]
[TD]Johnson[/TD]
[TD="align: right"]10/21/12[/TD]
[TD] 1,170.00[/TD]
[TD] 3,631.00[/TD]
[TD][/TD]
[TD]Mary[/TD]
[TD="align: right"]01/06/12[/TD]
[TD] 2,103.00[/TD]
[TD] 1,701.00[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD="align: right"]09/12/12[/TD]
[TD] 4,527.00[/TD]
[TD] 2,777.00[/TD]
[TD][/TD]
[TD]Johnson[/TD]
[TD="align: right"]11/09/12[/TD]
[TD] 2,641.00[/TD]
[TD] 2,651.00[/TD]
[TD][/TD]
[TD]Mary[/TD]
[TD="align: right"]03/04/12[/TD]
[TD] 2,003.00[/TD]
[TD] 3,570.00[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD="align: right"]10/24/12[/TD]
[TD] 4,980.00[/TD]
[TD] 2,061.00[/TD]
[TD][/TD]
[TD]Johnson[/TD]
[TD="align: right"]01/01/13[/TD]
[TD] 1,829.00[/TD]
[TD] 3,998.00[/TD]
[TD][/TD]
[TD]Mary[/TD]
[TD="align: right"]06/06/12[/TD]
[TD] 2,925.00[/TD]
[TD] 2,608.00[/TD]
[/TR]
</tbody>[/TABLE]


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.