find demurage smartly without CTRL F

[makinmomb]

I have sheet 1 that looks as follows

JOB NO:	WHARFAGE :	USD
TR-0506	BALLEYA ENT
TR-0446	S.F ENT
TR-0463	FALAY
TR-0430	LAURIANE
TR-0380	SOLOMON
JOB NO:	PORT CHARGES	USD
TR-0418	KALONJI - P/C	76
TR-0460	FALAY - P/C	117
TR-0454	PEARL - P/C	117
TR-0377	LUNGA - P/C	117
TR-0184	OM METAL - CHEMICAL - REM+STOR	384
JOB NO:	DELIVERY ORDER	USD
TR-0381	TESCO - DIAMOND	85

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[makinmomb]

On sheet 2 i have the follow

TR-0719-18

TR-0788-18

TR-0663-18

TR-0697-18

TR-0698-18

TR-0715-18

TR-0645-18

TR-0666-18

TR-0683-18

TR-0745-18

TR-0775-18

TR-0569-18

TR-0623-18

TR-0643-18

TR-0717-18

TR-0502-18

TR-0594-18

TR-0609-18

TR-0667-18

TR-0702-18

TR-0722-18

TR-0730-18

TR-0759-18

TR-0761-18

TR-0504-18

TR-0517-18

TR-0534-18

TR-0535-18

TR-0536-18

TR-0537-18

TR-0559-18

TR-0567-18

TR-0568-18

TR-0592-18

TR-0595-18

TR-0602-18

TR-0603-18

TR-0604-18

TR-0605-18

TR-0610-18

TR-0611-18

TR-0614-18

TR-0615-18

TR-0617-18

TR-0618-18

TR-0621-18

TR-0638-18

TR-0641-18

TR-0642-18

TR-0644-18

TR-0646-18

TR-0647-18

TR-0648-18

TR-0655-18

TR-0658-18

TR-0660-18

TR-0661-18

TR-0662-18

TR-0665-18

TR-0668-18

TR-0669-18

TR-0670-18

TR-0672-18

TR-0674-18

TR-0675-18

TR-0676-18

TR-0678-18

TR-0679-18

TR-0686-18

TR-0691-18

TR-0692-18

TR-0701-18

TR-0703-18

TR-0704-18

TR-0705-18

TR-0706-18

TR-0707-18

TR-0708-18

TR-0709-18

TR-0712-18

TR-0714-18

TR-0716-18

TR-0723-18

TR-0724-18

TR-0725-18

TR-0726-18

TR-0727-18

TR-0728-18

TR-0732-18

TR-0733-18

TR-0736-18

TR-0737-18

TR-0746-18

TR-0747-18

TR-0749-18

TR-0750-18

TR-0751-18

TR-0757-18

TR-0760-18

TR-0767-18

TR-0777-18

TR-0783-18

TR-0785-18

TR-0794-18

TR-0797-18

TR-0803-18

<colgroup><col></colgroup><tbody>
</tbody>

 

[makinmomb]

I want macro to go into sheet 1 look for the word DEMURAGE on b2 as header

Then see below that row on A1 where it will find the job number pasted above and pick its equivalent value on c and plug it besides the job numbers quoted , doing it through control f is long

 

[makinmomb]

Otherwise if this is not possible to find delete all rows and remain with only those rows that header DEMMURAGE on column b

 

[makinmomb]

Manually done data

TRANSROAD - 28/07/18
JOB NO:	DEMURRAGE	USD	APPROVED	DIFF	TSHS	APPROVED	DIFF	REMARKS
TR-0281	S.R DISTILLER-MSKU9095342-T454DJQ-MAERKS	380		380			-	CASH
TR-0204	NOVELTY-TCKU9875621-T604CAZ-MAERSK	1,735		1,735			-	CASH
TR-0125	KANKU-MNBU3021232-T848DCY-MAERSK	800		800			-	CASH
TR-0381	TESCO-TEMU7515641-T139CKG- EVERGREEN	-		-			-	CHQ -$60
TR-0427	BELTEXCO-TCKU3572042-T369BGZ-CMA	-		-			-	CHQ -$112
TR-0513	ZAMBIAN-TRHU3065025-T108BVH- CMA	-		-			-	CHQ -$176
TR-0514	AFRIGREEN-APHU6252053-T411CZS-CMA	-		-			-	CHQ -$352
ELVIN	CMA CGM	3,000		3,000			-	CASH
TRANSROAD - 30/07/18
JOB NO:	DEMURRAGE	USD	APPROVED	DIFF	TSHS	APPROVED	DIFF	REMARKS
TR-0281	S.R DISTILLER-MSKU9095342-T454DJQ-MAERKS	380	380	-			-	CASH
TR-0204	NOVELTY-TCKU9875621-T604CAZ-MAERSK	1,735		1,735			-	CASH
TR-0125	KANKU-MNBU3021232-T848DCY-MAERSK	800	800	-			-	CASH
ELVIN	CMA CGM	3,000		3,000			-	CASH

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