Trim data

[makinmomb]

TRANSROAD - 01/06/18
JOB NO:	WHARFAGE :	USD	APPROVED	DIFF	TSHS	APPROVED	DIFF	REMARKS
TR-0506	BALLEYA ENT			-	6,694,028		6,694,028
TR-0446	S.F ENT			-	546,468	546,468	-
TR-0463	FALAY			-	409,851	409,851	-
TR-0430	LAURIANE			-	546,468	546,468	-
TR-0380	SOLOMON			-	956,290	956,290	-	K& SONS
				-			-
JOB NO:	PORT CHARGES	USD	APPROVED	DIFF	TSHS	APPROVED	DIFF	REMARKS
TR-0418	KALONJI - P/C	76	76	-			-
TR-0460	FALAY - P/C	117	117	-			-
TR-0454	PEARL - P/C	117	117	-			-
TR-0377	LUNGA - P/C	117	117	-			-
TR-0184	OM METAL - CHEMICAL - REM+STOR	384	384	-			-
				-			-
JOB NO:	DELIVERY ORDER	USD	APPROVED	DIFF	TSHS	APPROVED	DIFF	REMARKS
TR-0381	TESCO - DIAMOND	85	85	-			-	$ 2000.00 DEPOSIT
				-			-
JOB NO:	DEMURRAGE	USD	APPROVED	DIFF	TSHS	APPROVED	DIFF	REMARKS
TR-0090	SHAZIA -MRKU4887520 - T299BKK - SAF	250		250			-	CASH
TR-0283	PAPILLON-TCKU1243114-T420DCC-SAF	295	295	-			-	CASH
TR-0241	ETS IGEC-CAIU7214813 -T553DMA-MAR	1,200	-	1,200			-	CASH

<colgroup><col><col><col span="6"><col></colgroup><tbody>
</tbody>

 

[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

TRANSROAD - 01/06/18
JOB NO:	PORT CHARGES	USD	APPROVED	DIFF	TSHS	APPROVED	DIFF	REMARKS
TR-0418	KALONJI - P/C	76	76	-			-
TR-0460	FALAY - P/C	117	117	-			-
TR-0454	PEARL - P/C	117	117	-			-
TR-0377	LUNGA - P/C	117	117	-			-
TR-0184	OM METAL - CHEMICAL - REM+STOR	384	384	-			-

<colgroup><col><col><col span="6"><col></colgroup><tbody>
</tbody>

 

[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