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