Data Segregation based on name criteria

[harinsh]

Hi All,

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

There is data in sheet1
{mod note: bad IMG tag removed}

 

[Jon von der Heyden]

Hi harinsh

The IMG tag you attempted does not work on this forum in the manner that you used and so I removed it.

I would encourage you to type a small post describing your problem. If you want to display a sample of your sheet (which you are also encouraged to do) - please read this thread: posting attachments.

 

[harinsh]

Hi Team,

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

[TABLE="class: cms_table, width: 263"]
<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="class: cms_table, width: 903"]
<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,