Good afternoon.
I am developing an evaluation tool that has a 4 point scale (Highly Effective (4) to Ineffective (1)).
<tbody>
</tbody>
I would like to click on B2 and a "4" would show up. If I clicked on C2, a "3" would show up in C2 and the "4" from B2 would go away.
Additionally, there are two evaluations, so F - I has the same Highly Effective to Ineffective setup. I would like those cells to do the same. Lastly, there are 4 sets of "Traits", so rows 2-5 have one set, rows 12 - 16 may have another set of traits, etc. I would like those to do the same as well.
Let me know if you need more details. Just trying to keep the project as confidential as possible.
I am using Excel 2007.
I am developing an evaluation tool that has a 4 point scale (Highly Effective (4) to Ineffective (1)).
Mr. Smith | Highly Effective | Effective | Developing | Ineffective |
Trait 1 | ||||
Trait 2 | ||||
Trait 3 | ||||
Trait 4 | ||||
<tbody>
</tbody>
I would like to click on B2 and a "4" would show up. If I clicked on C2, a "3" would show up in C2 and the "4" from B2 would go away.
Additionally, there are two evaluations, so F - I has the same Highly Effective to Ineffective setup. I would like those cells to do the same. Lastly, there are 4 sets of "Traits", so rows 2-5 have one set, rows 12 - 16 may have another set of traits, etc. I would like those to do the same as well.
Let me know if you need more details. Just trying to keep the project as confidential as possible.
I am using Excel 2007.