Trim 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]WHARFAGE : [/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-0506[/TD]
[TD]BALLEYA ENT [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] 6,694,028[/TD]
[TD] [/TD]
[TD] 6,694,028[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0446[/TD]
[TD]S.F ENT [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] 546,468[/TD]
[TD] 546,468[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0463[/TD]
[TD]FALAY [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] 409,851[/TD]
[TD] 409,851[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0430[/TD]
[TD]LAURIANE [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] 546,468[/TD]
[TD] 546,468[/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0380[/TD]
[TD]SOLOMON [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] 956,290[/TD]
[TD] 956,290[/TD]
[TD] - [/TD]
[TD] K& SONS [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]JOB NO: [/TD]
[TD]PORT CHARGES [/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-0418[/TD]
[TD]KALONJI - P/C [/TD]
[TD] 76[/TD]
[TD] 76[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0460[/TD]
[TD]FALAY - P/C [/TD]
[TD] 117[/TD]
[TD] 117[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0454[/TD]
[TD]PEARL - P/C [/TD]
[TD] 117[/TD]
[TD] 117[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0377[/TD]
[TD]LUNGA - P/C [/TD]
[TD] 117[/TD]
[TD] 117[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0184[/TD]
[TD]OM METAL - CHEMICAL - REM+STOR [/TD]
[TD] 384[/TD]
[TD] 384[/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]
[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-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] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]JOB NO: [/TD]
[TD]DEMURRAGE [/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-0090[/TD]
[TD]SHAZIA -MRKU4887520 - T299BKK - SAF [/TD]
[TD] 250[/TD]
[TD] [/TD]
[TD] 250[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] CASH [/TD]
[/TR]
[TR]
[TD]TR-0283[/TD]
[TD]PAPILLON-TCKU1243114-T420DCC-SAF[/TD]
[TD] 295[/TD]
[TD] 295[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] CASH [/TD]
[/TR]
[TR]
[TD]TR-0241[/TD]
[TD]ETS IGEC-CAIU7214813 -T553DMA-MAR[/TD]
[TD] 1,200[/TD]
[TD] - [/TD]
[TD] 1,200[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] CASH [/TD]
[/TR]
</tbody>[/TABLE]

 

[makinmomb]

I have the above data , I need macro to delete all rows remain with the date that is on merged sells
and remain with only data that has PORT CHARGES

Thus if the macro trims correctly the data will look as follows

[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]PORT CHARGES [/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-0418[/TD]
[TD]KALONJI - P/C [/TD]
[TD] 76[/TD]
[TD] 76[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0460[/TD]
[TD]FALAY - P/C [/TD]
[TD] 117[/TD]
[TD] 117[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0454[/TD]
[TD]PEARL - P/C [/TD]
[TD] 117[/TD]
[TD] 117[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0377[/TD]
[TD]LUNGA - P/C [/TD]
[TD] 117[/TD]
[TD] 117[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]TR-0184[/TD]
[TD]OM METAL - CHEMICAL - REM+STOR [/TD]
[TD] 384[/TD]
[TD] 384[/TD]
[TD] - [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] - [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[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]

Trying to break the file into expense types so that i can pull one time of info easily

 

[makinmomb]

Re pulling thread for someone to see it again