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
Bookmarks