Link on cells

Hello,

As per the attachment, I would like to have from the Index Tab the possibility to change acronym to name!

I have no clue what would be the best way to do that!

For example: I would need to be able to click on the B3 cell (hyperlink) and change the acronym "GGL" To "Graig LASTNAME". Clicking again on the displayname "Graig LASTNAME" I should get "GGL" etc...

I put 2 examples in the "database" sheet. Please let me know how would you create that sort of link on the cells??

Many thanks,
Graig

I tried and got the "circular reference Warning" Would that let me switch from acronym to displayname by clicking on the cell?

Thanks,

My bad. However, it is not what I need. C3 = GGL After a click on the acronym or C3 cell that cell should show the displayname. I should stay on the index tab

Just to clarify as I am not sure the attachment helps to understand better what I need:

So if I have in a simple excel worksheet the cell A1 equal to "GGL". I am looking for a way to change the acronym on the cell A1 to display the disply name corresponding to the acronym. So in this case and as per the attachment it should read "Graig Lastname"

I would like to have that "switch" occurring by clicking on the A1 cell. Please check the "link.jpg" attachment.

Many thanks,
graig

Can you please tell me how you did that!! It is just PERFECT!! many Thanks! It is exactly what I was expected! THANKS THANKS THANKS!!!!

@ Izandol: It works perfectly and I use it now in my original excel document. I just would like to ask if there is a limit? From the database worksheet, I can create hyperlink for about 50 rows. after it doesn't work. I checked the macro but I haven't see a limit. Can you please help me on that?

I remove blank rows and now it works perfectly Thanks again