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?
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?
