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
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