Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I would like to extend hyperlinks across cells | Excel Discussion (Misc queries) | |||
Preserving hyperlinks in linked cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Linking Cells and applying a sort | Excel Worksheet Functions | |||
linking cells colors | Excel Worksheet Functions |