Solved Using one sheet to access other sheets

April 19, 2012 at 08:24:06
Specs: Windows

I have multiple sheets in a workbook. My problem is that I want to create one sheet e.g. sheet 1 as a main sheet that displays the sheets name. For instance, my workbook contains of sheet2 name as data1, sheet3 name as data2 and so on. Sheet1 is the main sheet that displays the name of the sheet which is data1, data2. To access the data, the user just needs to click on the main sheet and it will automatically redirecting the user to the sheet that he/she clicked on. Is it possible? if yes, could anybody advise me on these? For information, I am a beginner in excel.

Thank you.


See More: Using one sheet to access other sheets

Report •


#1
April 19, 2012 at 10:24:29
✔ Best Answer

You can use the steps found here to manually create a hyperlinked Table of Contents:

http://chandoo.org/wp/2009/02/16/ex...

or you can use the steps found here to automatically create a hyperlinked Table of Contents:

http://blogs.office.com/b/microsoft...

DAGS on "Excel Table of Contents" for lots of hits and other ways to accomplish your goal.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
April 19, 2012 at 19:22:59

Thank you very much.

Report •

Related Solutions


Ask Question