Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calling a specific worksheet from a hyperlink in a seperate file.
Hi. New user on the forum. I'm working on some spreadsheets for tracking sales data at work. I have one worksheet which tracks overall numbers by salesman initials. I have another sheet that tracks individual sales. On the second sheet, each salesman has their own worksheet, one for every month. Example, employee AXK has 12 worksheets in the individual sales file: SEP-AXK, OCT-AXK, NOV-AXK, DEC-AXK, etc. What I want to do is, in the first file, the overall numbers tracker, I want to change their initials on each month to a hyperlink that opens their worksheet in the other file directly. The most I've managed is to turn it into a hyperlink to open the other file, but it opens to the last opened page. I haven't been able to specify what worksheet to open to directly. Any and all help would be greatly appreciated. Thanks. -- TheChris ------------------------------------------------------------------------ TheChris's Profile: http://www.excelforum.com/member.php...o&userid=31077 View this thread: http://www.excelforum.com/showthread...hreadid=507522 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening specific worksheet from hyperlink | Excel Discussion (Misc queries) | |||
Some formulas need file refresh in same worksheet | Excel Worksheet Functions | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
Excel should let hyperlink of PDF jump to a specific page like IE. | Excel Discussion (Misc queries) | |||
Hyperlink to specific worksheet in Excel | Links and Linking in Excel |