View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Rechie Rechie is offline
external usenet poster
 
Posts: 57
Default More than one Hyperlink for a single cell

In a simple way, If possible I need to have 3 links in a single cell (Project
Name), because this particular Project has 3 documents lying in other
places. In a normal sitiuation I have to type the same Project name in 3
different cell range (A1,A2 and A3) and link it individually to 3 different
Docs.

e.g.
A1= "Project A" link to Doc1
A2 = "Project A" link to Doc2
A3 = "Project A" link to Doc3

"Pete_UK" wrote:

I'm sorry, but that doesn't make any sense to me.

Please try to describe what you have and what you want to do with it.

Pete

On Oct 26, 11:20 am, Rechie wrote:
Hi ,
Example is in A1 =Main Project Name
Under this Main Project name , there are 3 more sub projects that I want to
link the details. Work sheet is only visible with MainProject .



"Pete_UK" wrote:
Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve.


Pete


On Oct 26, 8:00 am, Rechie wrote:
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.


.- Hide quoted text -


- Show quoted text -


.