I have an Excel file I am using as a grading rubric.
I have 5 different cells with text only in them. I need to be able to click on the cell and generate a score on the sixth cell, which is empty. For example, if I click on the first cell with text, the score is 1 and that 1 needs to appear in the sixth cell. If I click on the second cell with text, that score needs to be 2 and so on. I have no idea how to do this. Can someone guide me, please?![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
I have 5 different cells with text only in them. I need to be able to click on the cell and generate a score on the sixth cell, which is empty. For example, if I click on the first cell with text, the score is 1 and that 1 needs to appear in the sixth cell. If I click on the second cell with text, that score needs to be 2 and so on. I have no idea how to do this. Can someone guide me, please?
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)