Drisco
07-06-2010, 08:16 AM
I have been googling this for about half an hour and I've gotten pretty close but no cigar. I need to get this done for today as the boss is back today and wants to see it. It's not a real crucial part and could go with out but I'd rather keep it in..
Here is my issue.
I have two work different workbooks. Gas Management.xls and Fleet Management.xls
Inside Gas Management I have 35 sheets with 35 vehicles gas mileage tracked with flow charts, diagrams and pictures of the vehicles. Inside Fleet management I have who drove what car, what date and where they went and how far.
So for example. I want to make a link in say Car 4 sheet of Gas Management to Car 4 sheet in Fleet management.
I can get a link to the other workbook but not the specific sheet inside it.
I found these directions:
1. Select a cell where you want to place the hyperlink;
2. Type a description of the workbook you want to link to;
3. Right click on that cell and choose Hyperlink...;
4. Click the File... button and browse to the file location;
5. Select the file you want to link to and click OK;
6. If you want to go to a specific sheet in the workbook, click on the Bookmark... button, select the sheet name and click OK.
7. You can also click the Screen Tip... button to add a description to your hyperlink that will pop up when a user holds the mouse over the hyperlink.
8. Click OK to close the Insert Hyperlink dialog box and save your workbook.
9. Try out the hyperlink to see how it works.
So I go to bookmark click Car 3 sheet and hit okay, but when I click the link it says "That name is not valid" and just brings me to the Master Sheet of Fleet Management and not the specified sheet.
Any thoughts?
Here is my issue.
I have two work different workbooks. Gas Management.xls and Fleet Management.xls
Inside Gas Management I have 35 sheets with 35 vehicles gas mileage tracked with flow charts, diagrams and pictures of the vehicles. Inside Fleet management I have who drove what car, what date and where they went and how far.
So for example. I want to make a link in say Car 4 sheet of Gas Management to Car 4 sheet in Fleet management.
I can get a link to the other workbook but not the specific sheet inside it.
I found these directions:
1. Select a cell where you want to place the hyperlink;
2. Type a description of the workbook you want to link to;
3. Right click on that cell and choose Hyperlink...;
4. Click the File... button and browse to the file location;
5. Select the file you want to link to and click OK;
6. If you want to go to a specific sheet in the workbook, click on the Bookmark... button, select the sheet name and click OK.
7. You can also click the Screen Tip... button to add a description to your hyperlink that will pop up when a user holds the mouse over the hyperlink.
8. Click OK to close the Insert Hyperlink dialog box and save your workbook.
9. Try out the hyperlink to see how it works.
So I go to bookmark click Car 3 sheet and hit okay, but when I click the link it says "That name is not valid" and just brings me to the Master Sheet of Fleet Management and not the specified sheet.
Any thoughts?