Help please €¦

Scenario - I have a number of workbooks that have links to a €˜master to
manage days spent on about 20 projects. To make entering of relevant data
easier for the €˜Team leaders I would like to display only the projects that
relate to the team members even if they have not yet allotted time to it €“ ie
from below this would be P1 & P2 .

The table below is a very simplified version of the data, there are a number
of links both to and from the €˜master and a number of filters already
applied €¦ I think I can do this with a formula in an €˜Advanced Filter but
cannot work out how to display the rows that contain no data for some of the
team members €“ I have also tried with €˜If statements and €˜lookup but I
think I am making it more complicated than it is €¦ any thoughts would be
gratefully received €¦

Name Project Week 12 Week 13 Total
Mr A P1 3 3 6
P2 2 2 4
P3 0
Ms B P1 2 2 4
P2 0
P3 0
Mr C P1 0
P2 3 3 6
P3 0

Thanks in advance €¦
--
Thanks and have a good day

Ruth