2007.
Noob
I have ten seperate and different colored tables with 3 cells each:
Player #, Name, and Points.
I want a new table to display 30 cells:
Position, Name, and Points.
Obviously, I want the new table to be dynamic and have the Name and Point cells (as well as their respective cell colors) to change based on what position the player is at, as determined by how many points they have.
Just like a standings table in a newspaper.
For example:
A C E
1 Plyr1 Plyr2 Plyr 3
2 Joe Bob Matt
3 4 2 7
I want:
G H I
4 1st Matt 7
5 2nd Joe 4
6 3rd Bob 2
-with columns H & I changing (cell colors as well) as I change the values of row 3.
Is this possible?
Thanks in advance!
Noob
I have ten seperate and different colored tables with 3 cells each:
Player #, Name, and Points.
I want a new table to display 30 cells:
Position, Name, and Points.
Obviously, I want the new table to be dynamic and have the Name and Point cells (as well as their respective cell colors) to change based on what position the player is at, as determined by how many points they have.
Just like a standings table in a newspaper.
For example:
A C E
1 Plyr1 Plyr2 Plyr 3
2 Joe Bob Matt
3 4 2 7
I want:
G H I
4 1st Matt 7
5 2nd Joe 4
6 3rd Bob 2
-with columns H & I changing (cell colors as well) as I change the values of row 3.
Is this possible?
Thanks in advance!