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.
<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>
</tbody>
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
<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>
</tbody>
I hope this clarifies it a bit otherwise I happely send the full worksheet.
Thanks very much in advance!!!
Kind regards Tweeq
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.
| Case Reporting Queue | Case Owner: Full Name | Created By: Full Name | Date/Time Opened | Status | Case Age | Type | Insurance | Case Reason | Product | Origin | Destination | Country | Country | Shipment Date | Shipment Number | Case Number | Order Number | Shipper Account Nr | Account Reference | Account Name: Account Name | Receiver Name | Damaged Weight in KG | Claim Amount Currency | Claim Amount | Date/Time Closed | 1. Close Type | 1. Close Objectives | 1. Resolution Value Currency | 1. Resolution Value | 1. Transport Costs Currency | 1. Transport Costs | 1. Payment Type | 1. Other Reason | 1. Created By: Full Name | 1. Created Date | 1. Number of Claims | 1. Settlement Number |
| NL Claims | Tweeq | Clodie | 19-4-2016 11:19 | Closed | 35 | Claims | 0 | Damage | NL | NL | 26-1-2016 | 22613641 | 1126630 | 493317 TP Vision | Transporters | BCC | EUR | 7-6-2016 14:30 | Refund | Contract | EUR | 1 | EUR | Debet | Tweeq | 7-6-2016 | 1 | 2 | |||||||||
| NL Claims | Tweeq | Clodie | 19-4-2016 11:19 | Closed | 35 | Claims | 0 | Damage | NL | NL | 26-1-2016 | 22613641 | 1126630 | 493317 TP Vision | Transporters | BCC | EUR | 7-6-2016 14:30 | Refund | Contract | EUR | 2 | EUR | Credit | Tweeq | 9-5-2016 | 1 | 1 | |||||||||
| NL Claims | Tweeq | Clodie | 7-3-2016 14:38 | Closed | 11 | Claims | 0 | Damage | Woopsie | RTM | AMM | NL | NL | 11-2-2016 | 906475594 | 958232 | F-12208 | 5893771 | F-12208 | Transporters | BCC | 10 | EUR | 228 | 22-3-2016 12:37 | Information request | EUR | 3 | EUR | Tweeq | 22-3-2016 | 1 | 1 | ||||
| NL Claims | Tweeq | Clodie | 7-3-2016 14:38 | Closed | 11 | Claims | 0 | Damage | Woopsie | RTM | AMM | NL | NL | 11-2-2016 | 906475594 | 958232 | F-12208 | 5893771 | F-12208 | Transporters | BCC | 10 | EUR | 228 | 22-3-2016 12:37 | Refund | AVC | EUR | 4 | EUR | Credit | Tweeq | 22-3-2016 | 1 | 2 | ||
| NL Claims | Tweeq | Clodie | 24-3-2016 11:38 | Closed | 42 | Claims | 0 | Parcel lost | Woopsie | RTM | EHV | NL | 15-2-2016 | 907754994 | 1029180 | SC01361190 | 5976519 | SC01361190 | Transporters | BCC | 2 | EUR | 19,5 | 23-5-2016 14:54 | Rejected | EUR | 5 | EUR | Tweeq | 15-4-2016 | 1 | 1 |
<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>
</tbody>
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
| Case Reporting Queue | Case Owner: Full Name | Created By: Full Name | Date/Time Opened | Status | Case Age | Type | Insurance | Case Reason | Product | Origin | Destination | Country | Country | Shipment Date | Shipment Number | Case Number | Order Number | Shipper Account Nr | Account Reference | Account Name: Account Name | Receiver Name | Damaged Weight in KG | Claim Amount Currency | Claim Amount | Date/Time Closed | 1. Close Type | 1. Close Objectives | 1. Resolution Value Currency | 1. Resolution Value | 1. Transport Costs Currency | 1. Transport Costs | 1. Payment Type | 1. Other Reason | 1. Created By: Full Name | 1. Created Date | 1. Number of Claims | 1. Settlement Number | 2. Close Type | . Close Objectives | 2. Resolution Value Currency | 2. Resolution Value | 2. Transport Costs Currency | 2. Transport Costs | 2. Payment Type | 2. Other Reason | 2. Created By: Full Name | 2. Created Date | 2. Number of Claims | 2. Settlement Number |
| NL Claims | Tweeq | Clodie | 19-4-2016 11:19 | Closed | 35 | Claims | 0 | Damage | NL | NL | 26-1-2016 | 22613641 | 1126630 | 493317 TP Vision | Transporters | BCC | EUR | 7-6-2016 14:30 | Refund | Contract | EUR | 1 | EUR | Debet | Tweeq | 7-6-2016 | 1 | 2 | Refund | Contract | EUR | 2 | EUR | Credit | Tweeq | 9-5-2016 | 1 | 1 |
<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>
</tbody>
I hope this clarifies it a bit otherwise I happely send the full worksheet.
Thanks very much in advance!!!
Kind regards Tweeq
