Link to 2 diff worksheets same workbook - TechRepublic
General discussion
April 26, 2005 at 10:21 AM
c. boyd

Link to 2 diff worksheets same workbook

by c. boyd . Updated 21 years ago

I need to create 2 hyperlinks for an intranet web page each of which will open to a different worksheet in the same Excel workbook. I have created labels for each of the A1 cells. So, worksheet 1’s A1 is labeled “StepItUp” and worksheet 2’s label for A1 is “LightenUp”. When I use this it goes to worksheet 2, and when I use to also goes to worksheet 2. I’ve also tried, where #Step_It_up is the worksheet name and !stepitup is the label for cell A1 on that worksheet. It still goes to worksheet 2. I can’t believe there’s no way to create two hyperlinks on a webpage each of which goes to a different worksheet in the same workbook. Do you all have the solution?

This discussion is locked

All Comments