Pull not 38 and 39 data

[makinmomb]

[TABLE="width: 1305"]
<colgroup><col><col><col span="6"><col></colgroup><tbody>[TR]
[TD="colspan: 9"]TRANSROAD - 01/06/18[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]JOB NO: [/TD]
[TD]DELIVERY ORDER [/TD]
[TD] USD [/TD]
[TD] APPROVED [/TD]
[TD]DIFF[/TD]
[TD] TSHS [/TD]
[TD] APPROVED [/TD]
[TD]DIFF[/TD]
[TD]REMARKS [/TD]
[/TR]
[TR]
[TD]TR-0381[/TD]
[TD]TESCO - DIAMOND [/TD]
[TD] 85[/TD]
[TD] 85[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] $ 2000.00 DEPOSIT [/TD]
[/TR]
[TR]
[TD="colspan: 9"]TRANSROAD - 02/06/18[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD="colspan: 9"]TRANSROAD - 04/06/18[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]JOB NO: [/TD]
[TD]DELIVERY ORDER [/TD]
[TD] USD [/TD]
[TD] APPROVED [/TD]
[TD]DIFF[/TD]
[TD] TSHS [/TD]
[TD] APPROVED [/TD]
[TD]DIFF[/TD]
[TD]REMARKS [/TD]
[/TR]
[TR]
[TD]TR-0519[/TD]
[TD]BUILD CONNECT - CMA [/TD]
[TD] 38[/TD]
[TD] 38[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0515[/TD]
[TD]ESTABLISSEMENT - MSC [/TD]
[TD] 84[/TD]
[TD] 84[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]JOB NO: [/TD]
[TD]DELIVERY ORDER [/TD]
[TD] USD [/TD]
[TD] APPROVED [/TD]
[TD]DIFF[/TD]
[TD] TSHS [/TD]
[TD] APPROVED [/TD]
[TD]DIFF[/TD]
[TD]REMARKS [/TD]
[/TR]
[TR]
[TD]TR-0408[/TD]
[TD]FALAY - MAERSK [/TD]
[TD] 39[/TD]
[TD] 39[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0407[/TD]
[TD]FALAY - MAERSK [/TD]
[TD] 39[/TD]
[TD] 39[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0493[/TD]
[TD]NR INVESTMENT - MAERSK [/TD]
[TD] 39[/TD]
[TD] 39[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0387[/TD]
[TD]FALAY - MAERSK [/TD]
[TD] 39[/TD]
[TD] 39[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0423[/TD]
[TD]BELTEXCO - CMA [/TD]
[TD] 38[/TD]
[TD] 38[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0467[/TD]
[TD]FALAY - CMA [/TD]
[TD] 38[/TD]
[TD] 38[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0403[/TD]
[TD]PRINCE PHARMA - CMA [/TD]
[TD] 38[/TD]
[TD] 38[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0417[/TD]
[TD]FALAY - ONE SHIPPING [/TD]
[TD] 45[/TD]
[TD] 45[/TD]
[TD] - [/TD]
[TD] 100,000[/TD]
[TD] 100,000[/TD]
[TD] - [/TD]
[TD] UPLA [/TD]
[/TR]
[TR]
[TD="colspan: 9"]TRANSROAD - 06/06/18[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]JOB NO: [/TD]
[TD]DELIVERY ORDER [/TD]
[TD] USD [/TD]
[TD] APPROVED [/TD]
[TD]DIFF[/TD]
[TD] TSHS [/TD]
[TD] APPROVED [/TD]
[TD]DIFF[/TD]
[TD]REMARKS [/TD]
[/TR]
[TR]
[TD]TR-0516[/TD]
[TD]PRINCE PHARMA - CMA[/TD]
[TD] 38[/TD]
[TD] 38[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0503[/TD]
[TD]TESCO- CMA[/TD]
[TD] 38[/TD]
[TD] 38[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0507[/TD]
[TD]ARMAND - CMA[/TD]
[TD] 38[/TD]
[TD] 38[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0513[/TD]
[TD]ZAMBIAN CUTRAG - CMA [/TD]
[TD] 38[/TD]
[TD] 38[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0514[/TD]
[TD]AFRIGREEN - CMA [/TD]
[TD] 38[/TD]
[TD] 38[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0511[/TD]
[TD]BURAQ - CMA [/TD]
[TD] 38[/TD]
[TD] 38[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0510[/TD]
[TD]TESCO - DIAMOND [/TD]
[TD] 85[/TD]
[TD] 85[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] $2000 - CONTAINER DEPOSIT [/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

I have this data with header below as merged cells across a to i
TRANSROAD - 01/06/18

I want a macro that will pull me a summary where the TR number is not 38 and 39

 

[makinmomb]

Expected results on sheet 2 thus will look as follows

TR-0381 TESCO - DIAMOND 85 TR-0515 ESTABLISSEMENT - MSC 84
TR-0417 FALAY - ONE SHIPPING 45

 

[makinmomb]

And

TR-0510 TESCO - DIAMOND 85

 

[makinmomb]

I have this macro that converts the header which is merged cell to normal in
case it the macro has an issue with dealing with merged cells that are not merged anymore


https://www.mrexcel.com/forum/excel-questions/1072311-merge-cells-convert-normal.html

 

[makinmomb]

Is this macro short and simple , look for column c if not pull a along value c is which is not 38 or 39

 

[makinmomb]

Re pulling thread for someone to see it again