Excel / Automatically move complete row to another sheet
<p>I need to edit a excel spreadsheet so that a row automatically moves from one sheet ("Open_Followups") to another sheet ("Closed_Followups") if it contains "Yes" in column "I" ("Event completed/closed").</p>

<p>I have no experience in VBA and was wondering if someone here could help me creating the code? </p>

<p>Screenshot of the first columns in on the sheet.</p>

<p><a href="https://i.stack.imgur.com/3bGBv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3bGBv.png" alt="screenshot"></a>  </p>

<p>Not sure if it is important but I am using Excel 2016 on a Mac computer</p>