Hi,

I am not as great as my employers think I am in excel and have been asked to carry out the following task. They will have a master tab that has a table that looks something like this:

Task Assigned to Completion date

Task 1 Employee 1 June 2010
Task 2 Employee 2
Task 3 Employee 1 August 2010

Want they want is a separate tab for each different employee with their individual assignments that will automatically update when the master tab has been amended. Is this possible in Excel or would Access need to used.

Thanks in advance for the help.