this table is contain the data of every child
(with no formula inside that cell) :
<tbody>
</tbody>
i need that when i write the name of the child in second table (in column a )all that data from the first table about that child will write in the second table , like this :
<tbody>
</tbody>
thanks
(with no formula inside that cell) :
cell a1 | high | age | iq | grate in history | grate in biology | grate in geography | |||||
tomes | 6 | 8 | 77 | 77 | 76 | 98 | |||||
stave | 7 | 4 | 123 | 65 | 45 | 54 | |||||
brus | 3 | 38 | 145 | 98 | 87 | 32 | |||||
dan | 7 | 7 | 66 | 65 | 65 | 65 |
<tbody>
</tbody>
i need that when i write the name of the child in second table (in column a )all that data from the first table about that child will write in the second table , like this :
cell a7 | ||||||
tomer | 6 | 8 | 77 | 77 | 76 | 98 |
dan | 7 | 7 | 66 | 65 | 65 | 65 |
<tbody>
</tbody>
thanks