VBA Select Highest Column Dup

DisLeXic777

New Member
Joined
Jun 26, 2013
Messages
10
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]
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
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.
 
Upvote 0

Forum statistics

Threads
1,226,729
Messages
6,192,696
Members
453,747
Latest member
tylerhyatt04

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top