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