Help with Finding Matching Values and Updating a Different Value in 2 different workbooks

I have 2 files a Purchase Request and a Master BOM file that has a Parts summary sheet (see attached). They are mostly identical but serve different purposes. I am trying to write code so that I can update the line item status in the Parts Summary Sheet from the Purchase Request. The purchase Requests get updated periodically throughout the week and the project managers have to manually update their parts summary sheets in the Master BOM file so they can track their material. I am trying to stream line the process by updating them automatically
I am looking through the part numbers (Column F) and checking if the Line item status (Column R) is not “Released”, then searching for the part number on the Parts Summary sheet then updating the line item status.
I thought I was doing a good job with the code until I tried testing it. I had a few variables for the ranges that I tried to set and use but they error out when used so I had to remove the variable and type out the ranges to work in. Then when that got sorted out, I got an error in the .Find section.
Can someone help me find out what is going wrong?

Please Login or Register  to view this content.