Hi,

I suspect this is a simple query but i'm still a keen but ultimately VBA noob.

I have a to-do list in excel in the following format:

Column A - Task to be done.
Column B - Status (3 option drop down menu; Sorted, In Progress and Outstanding)
Column C - Additional notes.

I filter column B to exclude 'sorted' items but I have to manually refresh the filter to remove these completed items.

Is there any way I can build in an auto refresh feature, e.g. any time I select or amend a cell?

Thanks,

Snook