Perhaps using the Worksheet_Change event on column I (Eligibility) to re-run the recorded macro.

Of course that recorded macro would need to be cleaned up to eliminate all the .Select and .Selection stuff by use of variables.

Can't test any suggestions or ideas against a video.
As Pecoflyer says, you'll get better assistance attaching a sample workbook so we have something to work with.

Have you posted this same question to other forums ?