how can i copy/paste the word which is found during search in the current row wise

this code working but can i paste which word was found in the Row to its opposite Row

i my excel in column F

i have list of words which is to be serached and paste the which word found in the row(colored yellow)

IT IS POSSIBLE TO DO LIKE THIS

example like:

if i found the word CABLE in the row

D E

ELECTRICAL,CABLE, EXTENSION, 12V, 5 METER | CABLE
BELT, V, 376IN OC, 0.65625IN WD, 0.40625IN THK | BELT

Please Login or Register  to view this content.

i have added some line of code after this line If RngEnd.Row < RngBeg.Row Then Exit Sub

adding some line it is copying entire column of D

but i am trying to display only which full word was found in D reference to the F Column

should be displayed Only search words in E Column

i have attached file

Please Login or Register  to view this content.