New to the Board, help w/ hyperlinking

[thenine]

Hello,

I need some help with hyperlinking. I know how to hyperlink from a
cell, to a word document, to an excel document, and even to other cells
or worksheets within the same document.

My question is how do you hyperlink from a cell to a specific worksheet
inside of a seperte excel file?


basically i want to click on a link in one excel file and have that
link pull up a specific worksheet inside of difrent excel file.

Thanks for the help

 

[David McRitchie]

Hi Thenine,
Ctrl+K or right click on cell, hyperlinks
look at the symbols on the left

as a worksheet function see
Worksheets in VBA Coding and in Worksheet Formulas
http://www.mvps.org/dmcritchie/excel/sheets.htm

=HYPERLINK("[c:\temp\project_text.xls]'Menu Sheet'!a18", "nice description")
=HYPERLINK("[vlookup.xls]'" & A5 & "'!C5","'" & A5 & "'!C5")
=HYPERLINK("file://x:/mywebsite/dmcritchie/excel/" & A6 & ".htm",A6)
=HYPERLINK("http://www.mvps.org/dmcritchie/excel/" & A7 & ".htm",A7)

 

[David McRitchie]

Actually the four main Excel groups are:

microsoft.public.excel.misc
- general questions

microsoft.public.excel.newusers
--- new users, questions aren't any simpler though

microsoft.public.excel.worksheet.functions
-- builtin worksheet functions

microsoft.public.excel.programming
-- VBA question / macros /user defined functions