I have in a column a range of cells label tyke #1 thru to
Tyke # 8 (A2:A9) columns (B1:CE1) are labelled as days of
the week. the range (B2:CE9) is the schedule for the teams
I would like that when I enter "P2" in any column (b1:ce1)
on row A2 that it automatically know to put "P1" in row A3
and if I enter "H3" in row A8 it automatically puts "G7" in
row A4 and vice versa. Basically as soon as I enter either
"P1-8" or "H1-8" or "G1-8" in any cell with the
range(B2:CE9) it will put the corresponding entry in the
same column. (note; no team can practice or play against
itself) I have a spread sheet with over 4000 games
practices to do and if someone out there knows how to do
this ican modify it to make it work for all levels that i
hae to schedule. thanks