Linking Hyperlinks into different cells
I have got a front sheet with several selections to make. This is
transfered onto a hidden sheet where it uses an autofitler to narrow the search down to one row. On this row there are several numbers which I transfer onto the front page. I also need to transfer a hyperlink onto the front sheet. I can transfer the text of the hyperlink, using this: {=INDEX(K11:K304,MATCH(1,SUBTOTAL(3,OFFSET(K11:K30 4,ROW(K11:K304)-MIN(ROW (K11:K304)),,1)),0))} I cannot transfer the hyperlink itself, does anyone know how to do this? Thanks in advance, Gav -- Message posted via http://www.officekb.com |
Untested:
=hyperlink(yourformula) But if this works, it'll make anything that's returned into a link. (It uses the value in the cell--not the link (added via insert|hyperlink). "Gav via OfficeKB.com" wrote: I have got a front sheet with several selections to make. This is transfered onto a hidden sheet where it uses an autofitler to narrow the search down to one row. On this row there are several numbers which I transfer onto the front page. I also need to transfer a hyperlink onto the front sheet. I can transfer the text of the hyperlink, using this: {=INDEX(K11:K304,MATCH(1,SUBTOTAL(3,OFFSET(K11:K30 4,ROW(K11:K304)-MIN(ROW (K11:K304)),,1)),0))} I cannot transfer the hyperlink itself, does anyone know how to do this? Thanks in advance, Gav -- Message posted via http://www.officekb.com -- Dave Peterson |
Cheers Dave, but that didnt work, it gave a hyperlink, but didnt have an
address to go to. Any other suggestions? Gav -- Message posted via http://www.officekb.com |
That =hyperlink() uses the value returned.
If your returned value isn't a valid hyperlink, then maybe you could convert it to one: =hyperlink("http://" & yourformula) If the value returned was missing the http:// portion. If that doesn't work, what do you see in the cell? "Gav via OfficeKB.com" wrote: Cheers Dave, but that didnt work, it gave a hyperlink, but didnt have an address to go to. Any other suggestions? Gav -- Message posted via http://www.officekb.com -- Dave Peterson |
All times are GMT +1. The time now is 05:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com