VBA Index Match add Row

Hello, I am new to VBA and came up with some code that does what I need but after a week I am stuck. I have 700 files that I need to run this on . There are Files that start with PL they need to be updated using the RM File. The file that says complete is what it should look like after it is done.

Basically want to match a part number from the PL Files to the RM File if match found add row below. Copy PL file Part Number to offset -1 column in new row and the rest of the data will be filled in from the RM file. The COMPLETE file has some VBA I was able to work out but its just not coming together. Below is a image explaining the complete file.

Thank you to anyone that is able to she some light on this, I am at a dead end.

Output.png

Hello Bernie

Thank you and you assumptions were correct that was a typo and all the files are in the same spot. I ran the code and worked perfectly but I messed up. Is there a way to tweek the create row condition. If match found in column D in RM file then check Column F for value then create row. If column F in Rm file blank do not add row. Then copy Column F & Column G like you the VBA says then preform index match to get values for PL files column M & N. I upload a picture to show the differences the highlighted values are off. Thank you again this was a life safer.

Attachment 781879

Yeah the RM File has values for M & N so they would be added to both new and old rows. All the rows after the new row is added need to get the values from RM File Column I and Column E and place the value in the PL files column M & N.

I replaced the code but it did nothing to the file.

I removed all blanks in column F from my RM file and them the code added the rows correctly. And after that action this part should happen to all the parts in column I matched and find and copy this part
wsW.Cells(lngR + 1, "M").Value = wsRM.Cells(rngF.Row, "I").Value
wsW.Cells(lngR + 1, "N").Value = wsRM.Cells(rngF.Row, "E").Value