Two related tables

Hi Everyone,

I am trying to create an excel sheet that allows me to see both who is working on a project and what projects a person is working on. This dual view is causing me a nightmare! I have attached a spreadsheet to show the type of thing I am trying to create.

The dates are the week commencing and the numbers are the percentage of time a person is allocated to that project. The purpose of the spread sheet is to give an easy indication of how many people in total work on a particular project and what is an individual’s workload. By selecting from the dropdown in cell B2 the table would change to the relevant person or project.

I want to be able to only update one sheet and the other will automatically update. Ideally I would like to be able to update either, but if this is not possible then the ability to update the person sheet is most important and the project sheet can run off that.

There are about 50 people but this number is constantly changing, and about 7 projects which is also a changing number so the ability to add new people / projects without much work is vital.

I hope you can help.

Thanks in advance,

Ger