Hyperlinks
Posted by Peter on September 06, 2000 3:07 PM
Hiya all, hoping someone can help me.
I have a spreadsheet, that contains approximately 240 hyperlinks to documents withing the spreadsheet. Because of the dynmaics of the data it is continually re-sorted and re-calculated. What I am trying to achieve is to copy a hyperlink with an if statement.
Example
Insert a hyperlink at cell a1
Insert an IF statement in cell a2 along the lines of =IF(A1<>"",A1,"")
Notice that the hyperlink does not copy with the if statement. I need it to copy.
Thanking you all in advance
Posted by Ivan Moala on September 07, 0100 2:20 AM
Try putting this rather long formula in a cell
=IF(A1="","",HYPERLINK(LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1) & MID(CELL("filename"),LEN(CELL("filename"))-1-FIND("[",CELL("filename")),LEN(CELL("filename"))-FIND(".",CELL("filename"))+3),A1))
The only draw back to this formula is that you have to double click the link to activate it.
Ivan
