Hello,

Not being an excel wizard I need some help on this one. I
have a summary sheet of a number of differnt teams at
work, then in four different worksheets I have the same
teams and their goals and whether they have met them or
not on a rolling weekly basis for 10wks.

What I want to do in the summary sheet is say look at this
teams performance in Worksheet 1 and if they have failed
for the week put a F or colour red in the summary
spreadsheet. Then look at the next teams performance and
so on.

Any ideas would be much appreciated.