I am pretty new to this so excuse my ignorance.

I finally got Auofilter to work so i am pretty happy.

We have a master sheet which has all the tasks all employees are working on.
We use an x to dictate a column where someone has to do it.

The master work sheet may look like this

Date Task EmpName1 EmpName2 EmpName3
1-nov Call client x
1-nov Attend meeting x x
2-nov Photocopy Doc x


I created a workheet for each employee by referencing everything in the
master sheet (i.e for a1 in EmpName1 i just put =master!a1) - and then
applying an autofilter with "x" as the criteria for each employee worksheet.

so the EmpName1 worksheet would look like this

Date Task EmpName1 EmpName2 EmpName3
1-nov Call client x
1-nov Attend meeting x x


This all works really well except when new tasks are added to the Master
worksheet - for the task to show up on each employees worksheet they need to
go and "re-filter" using the x selection to bring up the new tasks. Ideally I
would like this to be automated. is this possible?

Thanks in advance