Hello my expert friends!
I have a worksheet where I have a column for status and a column for progress (Status = column I & In Progress = column J). What I do is, change In Progress to Yes and when finished, status gets a value added to it. What I would like to do is when a value gets added to status, the In Progress field in that row gets cleared.
The spreadsheet is new every day so the amount of rows will be different. Is there code that will allow me to work this out?