Pull not 38 and 39 data

[makinmomb]

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

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

 

[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