Auto filter a task list

**issowaves** · 09-10-2011, 08:55 AM

hi,

i'm trying to create a task-list that will auto-filter whenever the data has been changed in column B.

The column set runs from B to E
The row set runs from 2 to 35.

Is it possible to the have to automatically filter the data when the data has been changed in column B?

any help will be great.

**MarvinP** · 09-10-2011, 09:33 AM

Hi issowaves and welcome to the forum,

Find the attached that does what you want.

I've recorded a macro to simply sort task list 1 by priority. Then created an event macro behind the worksheet to only do the sort macro if a priority changes or is added.

Hope this works for you.