VBA: Update cell value based on change in another sheets cell

[lunatu]

Hi,

I’m operating with two sheets: “sheet1” from where I want to automatically copy row to “sheet2” when the column “status” = “in progress”. I have that macro already running perfectly - BUT, now I need to figure out macro which will update the sheet1 status when case is closed sheet2 status column = “closed”. The problem is that the code should find the right cell to update, common value in both sheets is “PordCode”.

Any ideas how to solve this?

Thanks in advance