excel help.jpg
Hello guys,
Basically it is a training matrix.
I know this is possible and probably easy to implement but i haven't got a clue lol
basically I need A30, A32, A34 and A36 cells to display the characters they are currently displaying but when i copy and past any of them into a new cell on the matrix for example into cell B11 I want to be able to SUM the total of that column and display it in cell B24
So to recap, I would like A30, A32, A34 and A36 cells to hold 25, 50, 75 and 100 as there value but this can not be displayed it is just a value which i can use to calculate.
I am ok if i have to link the cells with another worksheet but i have tried doing this also i dont know if i need to use VBA.
Please advise me to the best solution. Thanks
Bookmarks