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!