VBA or Formula EXEL

T

Tweeq

New Member
Joined
Jun 22, 2016
Messages
1
Hi all,

first things first since im new. HI ALL and hopefully u guys/girls can help.

I have an issue of course regarding Excel. A department is creating raports regarding claims and since Im an IT guy i know everything (uhuh)

This is my problem.

Every month I receive a raport regarding different claims for, sometimes the same customer, sometimes different ones.
Every action done on that claim will log a new rule/row.

ex.
[TABLE="width: 4823"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Case Reporting Queue[/TD]
[TD]Case Owner: Full Name[/TD]
[TD]Created By: Full Name[/TD]
[TD]Date/Time Opened[/TD]
[TD]Status[/TD]
[TD]Case Age[/TD]
[TD]Type[/TD]
[TD]Insurance[/TD]
[TD]Case Reason[/TD]
[TD]Product[/TD]
[TD]Origin[/TD]
[TD]Destination[/TD]
[TD]Country[/TD]
[TD]Country[/TD]
[TD]Shipment Date[/TD]
[TD]Shipment Number[/TD]
[TD]Case Number[/TD]
[TD]Order Number[/TD]
[TD]Shipper Account Nr[/TD]
[TD]Account Reference[/TD]
[TD]Account Name: Account Name[/TD]
[TD]Receiver Name[/TD]
[TD]Damaged Weight in KG[/TD]
[TD]Claim Amount Currency[/TD]
[TD]Claim Amount[/TD]
[TD]Date/Time Closed[/TD]
[TD]1. Close Type[/TD]
[TD]1. Close Objectives[/TD]
[TD]1. Resolution Value Currency[/TD]
[TD]1. Resolution Value[/TD]
[TD]1. Transport Costs Currency[/TD]
[TD]1. Transport Costs[/TD]
[TD]1. Payment Type[/TD]
[TD]1. Other Reason[/TD]
[TD]1. Created By: Full Name[/TD]
[TD]1. Created Date[/TD]
[TD]1. Number of Claims[/TD]
[TD]1. Settlement Number[/TD]
[/TR]
[TR]
[TD]NL Claims[/TD]
[TD]Tweeq[/TD]
[TD]Clodie[/TD]
[TD="align: right"]19-4-2016 11:19[/TD]
[TD]Closed[/TD]
[TD="align: right"]35[/TD]
[TD]Claims[/TD]
[TD="align: right"]0[/TD]
[TD]Damage[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]NL[/TD]
[TD]NL[/TD]
[TD="align: right"]26-1-2016[/TD]
[TD="align: right"]22613641[/TD]
[TD="align: right"]1126630[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]493317 TP Vision[/TD]
[TD]Transporters[/TD]
[TD]BCC[/TD]
[TD] [/TD]
[TD]EUR[/TD]
[TD] [/TD]
[TD="align: right"]7-6-2016 14:30[/TD]
[TD]Refund[/TD]
[TD]Contract[/TD]
[TD]EUR[/TD]
[TD="align: right"]1[/TD]
[TD]EUR[/TD]
[TD] [/TD]
[TD]Debet[/TD]
[TD] [/TD]
[TD]Tweeq[/TD]
[TD="align: right"]7-6-2016[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]NL Claims[/TD]
[TD]Tweeq[/TD]
[TD]Clodie[/TD]
[TD="align: right"]19-4-2016 11:19[/TD]
[TD]Closed[/TD]
[TD="align: right"]35[/TD]
[TD]Claims[/TD]
[TD="align: right"]0[/TD]
[TD]Damage[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]NL[/TD]
[TD]NL[/TD]
[TD="align: right"]26-1-2016[/TD]
[TD="align: right"]22613641[/TD]
[TD="align: right"]1126630[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]493317 TP Vision[/TD]
[TD]Transporters[/TD]
[TD]BCC[/TD]
[TD] [/TD]
[TD]EUR[/TD]
[TD] [/TD]
[TD="align: right"]7-6-2016 14:30[/TD]
[TD]Refund[/TD]
[TD]Contract[/TD]
[TD]EUR[/TD]
[TD="align: right"]2[/TD]
[TD]EUR[/TD]
[TD] [/TD]
[TD]Credit[/TD]
[TD] [/TD]
[TD]Tweeq[/TD]
[TD="align: right"]9-5-2016[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]NL Claims[/TD]
[TD]Tweeq[/TD]
[TD]Clodie[/TD]
[TD="align: right"]7-3-2016 14:38[/TD]
[TD]Closed[/TD]
[TD="align: right"]11[/TD]
[TD]Claims[/TD]
[TD="align: right"]0[/TD]
[TD]Damage[/TD]
[TD]Woopsie[/TD]
[TD]RTM[/TD]
[TD]AMM[/TD]
[TD]NL[/TD]
[TD]NL[/TD]
[TD="align: right"]11-2-2016[/TD]
[TD="align: right"]906475594[/TD]
[TD="align: right"]958232[/TD]
[TD]F-12208[/TD]
[TD="align: right"]5893771[/TD]
[TD]F-12208[/TD]
[TD]Transporters[/TD]
[TD]BCC[/TD]
[TD="align: right"]10[/TD]
[TD]EUR[/TD]
[TD="align: right"]228[/TD]
[TD="align: right"]22-3-2016 12:37[/TD]
[TD]Information request[/TD]
[TD] [/TD]
[TD]EUR[/TD]
[TD="align: right"]3[/TD]
[TD]EUR[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Tweeq[/TD]
[TD="align: right"]22-3-2016[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]NL Claims[/TD]
[TD]Tweeq[/TD]
[TD]Clodie[/TD]
[TD="align: right"]7-3-2016 14:38[/TD]
[TD]Closed[/TD]
[TD="align: right"]11[/TD]
[TD]Claims[/TD]
[TD="align: right"]0[/TD]
[TD]Damage[/TD]
[TD]Woopsie[/TD]
[TD]RTM[/TD]
[TD]AMM[/TD]
[TD]NL[/TD]
[TD]NL[/TD]
[TD="align: right"]11-2-2016[/TD]
[TD="align: right"]906475594[/TD]
[TD="align: right"]958232[/TD]
[TD]F-12208[/TD]
[TD="align: right"]5893771[/TD]
[TD]F-12208[/TD]
[TD]Transporters[/TD]
[TD]BCC[/TD]
[TD="align: right"]10[/TD]
[TD]EUR[/TD]
[TD="align: right"]228[/TD]
[TD="align: right"]22-3-2016 12:37[/TD]
[TD]Refund[/TD]
[TD]AVC[/TD]
[TD]EUR[/TD]
[TD="align: right"]4[/TD]
[TD]EUR[/TD]
[TD] [/TD]
[TD]Credit[/TD]
[TD] [/TD]
[TD]Tweeq[/TD]
[TD="align: right"]22-3-2016[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]NL Claims[/TD]
[TD]Tweeq[/TD]
[TD]Clodie[/TD]
[TD="align: right"]24-3-2016 11:38[/TD]
[TD]Closed[/TD]
[TD="align: right"]42[/TD]
[TD]Claims[/TD]
[TD="align: right"]0[/TD]
[TD]Parcel lost[/TD]
[TD]Woopsie[/TD]
[TD]RTM[/TD]
[TD]EHV[/TD]
[TD] [/TD]
[TD]NL[/TD]
[TD="align: right"]15-2-2016[/TD]
[TD="align: right"]907754994[/TD]
[TD="align: right"]1029180[/TD]
[TD]SC01361190[/TD]
[TD="align: right"]5976519[/TD]
[TD]SC01361190[/TD]
[TD]Transporters[/TD]
[TD]BCC[/TD]
[TD="align: right"]2[/TD]
[TD]EUR[/TD]
[TD="align: right"]19,5[/TD]
[TD="align: right"]23-5-2016 14:54[/TD]
[TD]Rejected[/TD]
[TD] [/TD]
[TD]EUR[/TD]
[TD="align: right"]5[/TD]
[TD]EUR[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Tweeq[/TD]
[TD="align: right"]15-4-2016[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

As u can see some look very similar.

What i would like to do is every action that is done on the same shipment and or shipper account number in 1 singe row. where the oldest is first and then goes up.

Ex. for rule 1 and 2

[TABLE="width: 5969"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Case Reporting Queue[/TD]
[TD]Case Owner: Full Name[/TD]
[TD]Created By: Full Name[/TD]
[TD]Date/Time Opened[/TD]
[TD]Status[/TD]
[TD]Case Age[/TD]
[TD]Type[/TD]
[TD]Insurance[/TD]
[TD]Case Reason[/TD]
[TD]Product[/TD]
[TD]Origin[/TD]
[TD]Destination[/TD]
[TD]Country[/TD]
[TD]Country[/TD]
[TD]Shipment Date[/TD]
[TD]Shipment Number[/TD]
[TD]Case Number[/TD]
[TD]Order Number[/TD]
[TD]Shipper Account Nr[/TD]
[TD]Account Reference[/TD]
[TD]Account Name: Account Name[/TD]
[TD]Receiver Name[/TD]
[TD]Damaged Weight in KG[/TD]
[TD]Claim Amount Currency[/TD]
[TD]Claim Amount[/TD]
[TD]Date/Time Closed[/TD]
[TD]1. Close Type[/TD]
[TD]1. Close Objectives[/TD]
[TD]1. Resolution Value Currency[/TD]
[TD]1. Resolution Value[/TD]
[TD]1. Transport Costs Currency[/TD]
[TD]1. Transport Costs[/TD]
[TD]1. Payment Type[/TD]
[TD]1. Other Reason[/TD]
[TD]1. Created By: Full Name[/TD]
[TD]1. Created Date[/TD]
[TD]1. Number of Claims[/TD]
[TD]1. Settlement Number[/TD]
[TD]2. Close Type[/TD]
[TD]. Close Objectives[/TD]
[TD]2. Resolution Value Currency[/TD]
[TD]2. Resolution Value[/TD]
[TD]2. Transport Costs Currency[/TD]
[TD]2. Transport Costs[/TD]
[TD]2. Payment Type[/TD]
[TD]2. Other Reason[/TD]
[TD]2. Created By: Full Name[/TD]
[TD]2. Created Date[/TD]
[TD]2. Number of Claims[/TD]
[TD]2. Settlement Number[/TD]
[/TR]
[TR]
[TD]NL Claims[/TD]
[TD]Tweeq[/TD]
[TD]Clodie[/TD]
[TD="align: right"]19-4-2016 11:19[/TD]
[TD]Closed[/TD]
[TD="align: right"]35[/TD]
[TD]Claims[/TD]
[TD="align: right"]0[/TD]
[TD]Damage[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]NL[/TD]
[TD]NL[/TD]
[TD="align: right"]26-1-2016[/TD]
[TD="align: right"]22613641[/TD]
[TD="align: right"]1126630[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]493317 TP Vision[/TD]
[TD]Transporters[/TD]
[TD]BCC[/TD]
[TD] [/TD]
[TD]EUR[/TD]
[TD] [/TD]
[TD="align: right"]7-6-2016 14:30[/TD]
[TD]Refund[/TD]
[TD]Contract[/TD]
[TD]EUR[/TD]
[TD="align: right"]1[/TD]
[TD]EUR[/TD]
[TD] [/TD]
[TD]Debet[/TD]
[TD] [/TD]
[TD]Tweeq[/TD]
[TD="align: right"]7-6-2016[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Refund[/TD]
[TD]Contract[/TD]
[TD]EUR[/TD]
[TD="align: right"]2[/TD]
[TD]EUR[/TD]
[TD] [/TD]
[TD]Credit[/TD]
[TD] [/TD]
[TD]Tweeq[/TD]
[TD="align: right"]9-5-2016[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

I hope this clarifies it a bit otherwise I happely send the full worksheet.

Thanks very much in advance!!!

Kind regards Tweeq
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You must log in or register to reply here.

Similar threads

C
  • Question Question
VBA for matching Credit Card Refunds
Replies
2
Views
165
CellMaster
C
L
  • Question Question
Sending Email with Table in Body
Replies
3
Views
519
Domenic
D
E
  • Solved
[VBA] File saving does not work/new version not uploaded
Replies
4
Views
707
NdNoviceHlp
NdNoviceHlp
A
  • Question Question
VBA : Audit Selector Based on Task with no repeated user.
Replies
0
Views
179
AmirFirdaus9509
A
J
  • Question Question
Created Macro That Formats Sales Data through power query and keep getting errors when I try and run it
Replies
1
Views
695
Fluff
Fluff

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

Share this page

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