Help with formula

[Hooter]

Hi

I have been here before and the help was great.
OK
What I need to do is have a formula which transfers scores. I have a main
league
with 42 people on it which I update each person individually.
example
Name Week 7 TTL
F. Bloggs 42 400
C. Smith 36 395
B. Brown 56 356
C. White 45 354
D. Dunn 65 300
R. Ball 20 256

I want to create some mini leagues (different part of spread sheet separate
cells) with certain people in it
example
C. White 45 354
D. Dunn 65 300
R. Ball 20 256

So when I update the main league, the mini leagues with certain people in
them also update with the
score I have given them on the main league.

does this make sense

Many thanks Simon

 

[Sherr]

If your main league is at A:C including your Titles and
your mini league is at AA:AC,this simple way may help.

Assuming that you don't change the order of your main
league, you could substitute the people in AA with their
name i.e.(R.Ball sample at AA7:AC7.
A B C AA AB AC
1 Name Week 7 TTL
2 F.Bloggs 42 400 =A5 =B5 =C5
3 C.Smith 36 395 =A6 =B6 =C6
4 B.Brown 56 356 =A7 =B7 =C7
5 C.White 45 354
6 D.Dunn 65 300
7 R.Ball 20 256 R.Ball =B7 =C7

 

[Hooter]

Sherr
I will be sorting the league table by most points, so names will change
position.