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.

Try

Please Login or Register  to view this content.

Fluff13, thanks got through the Find statement, but now it errors out in the if statement when I try to update the status field.

Please Login or Register  to view this content.

What error do you get?

Fluff, I figured it out. Someone deleted columns from the sheet we are updating so my offset (, 17) was trying to go into the wrong locked cell. I have to add the columns back in and change the password so no one will be able to mess with the file again. Sorry I should have checked the hidden columns and caught it.

Glad you figured it out & thanks for the feedback

Thanks for the help. Another simple one that I just could not see.