Hyperlinking with formula to new workbook

[boll55]

Hi, I have, hopefully, a simple and easy question.

I have a formula that give me a hyperlink to a workbook:

=HYPERLINK("\\Z:\Safety\Sisbro\Accident Reports\Acc Reports MASTER.xlsm", A1)

a1 is the location where it takes me and although this is FABULOUS i do wish to tweek it just a little bit. I would now like it to not only take me to the workbook but to also take me to the corrct worksheet in that work book. I have been using a formula for creating a hyperlink:

=HYPERLINK("#"&"'"&K2&"'!"&N2,L2&" "&TEXT(M2,"M-D-YY"))

which also works FABULOUS. I now want to somehow combine the two if that's possible...

Make sense?

Thanks!

[ajryan88]

Hi,

Try this combined formula:

Please Login or Register  to view this content.

NB: This is untested, but I think it will work

Hope this helps