Update cell based on hyperlink selected without using macro

[Kumar Shanmugam]

Hi.

I wanted to hyperlink all 3 cells to a single cell which will updated based on hyperlink selected. I wanted to do it without using macro.

I have found a solution for the same where macro has been used - https://www.techonthenet.com/excel/hyperlinks/update_cell2013.php

Please suggest a solution for the same without using macro.

Sample data attached.

 

[Chihiro]

Short answer, you can't.

Long answer, short of using Macro, there isn't a way to trap hyperlink clicked and pass it on to another cell.