Hyperlink to a specific worksheet in another workbook
hi
i think your question was answered in the previous post but try something
like this....
=HYPERLINK([workbook1.xls]sheet1!$A$1,"gotoit1")
regards
FSt1
"Romileyrunner1" wrote:
Hi,
is there a way to hyperlink from one workbook to a specific worksheet in
another workbook.
I have a collumn of numbers from 1-80.
I would like to click on each cell and be taken to a corresponding worksheet
numbered 1-80 ina diffferent workbook.
I can easily go to that workbook but I can`t specify the worksheet: it just
takes me to the last viewed worksheet.
Any ideas guys?
Thanks
RR1
|