VBA Select Highest Column Dup

[DisLeXic777]

Hi All,

I have a few thousand rows of data like table A with different names and T counts but the same $ amount and same date ranges. I would like to format the date to look like date B,
so if the name,date ranges, and $ amount are the same then grab the highest T count and put it into a new sheet. I am having issues with this as I cannot get my loop to copy the needed values. Can anyone steer me in the right direction?

Thanks


TABLE A

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]DateSt[/TD]
[TD]DateEd[/TD]
[TD]T1[/TD]
[TD]T2[/TD]
[TD]T3[/TD]
[TD]T4[/TD]
[TD]T5[/TD]
[/TR]
[TR]
[TD]Cidy,Windy[/TD]
[TD]03/15/2011[/TD]
[TD]09/15/2013[/TD]
[TD]6 [/TD]
[TD]2 [/TD]
[TD]3[/TD]
[TD]9 [/TD]
[TD]$3,469[/TD]
[/TR]
[TR]
[TD]Jack,Russel[/TD]
[TD]02/2/28[/TD]
[TD]04/5/2012[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]$2,315[/TD]
[/TR]
[TR]
[TD]Cidy,Windy[/TD]
[TD]03/15/2011[/TD]
[TD]09/15/2013[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD]$3,469[/TD]
[/TR]
[TR]
[TD]Jack,Russel[/TD]
[TD]02/2/28[/TD]
[TD]04/5/2012[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD]$2,315[/TD]
[/TR]
[TR]
[TD]Jack,Russel[/TD]
[TD]02/2/28[/TD]
[TD]04/5/2012[/TD]
[TD]10[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]15[/TD]
[TD]$2,315[/TD]
[/TR]
</tbody>[/TABLE]


TABLE B

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]DateSt[/TD]
[TD]DateEd[/TD]
[TD]T1[/TD]
[TD]T2[/TD]
[TD]T3[/TD]
[TD]T4[/TD]
[TD]T5[/TD]
[/TR]
[TR]
[TD]Cidy,Windy[/TD]
[TD]03/15/2011[/TD]
[TD]09/15/2013[/TD]
[TD]6 [/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]9 [/TD]
[TD]$3,469[/TD]
[/TR]
[TR]
[TD]Jack,Russel[/TD]
[TD]02/2/28[/TD]
[TD]04/5/2012[/TD]
[TD]10[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]15[/TD]
[TD]$2,315[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[lrobbo314]

Make your life simple and turn this into a Pivot Table. Add Dates and T1-T5 as Values, and Name as Row Label. Then change all of the items in the Values to Max.

 

[DisLeXic777]

Make your life simple and turn this into a Pivot Table. Add Dates and T1-T5 as Values, and Name as Row Label. Then change all of the items in the Values to Max.

Simple and Effective..

Thanks Irobbo314