Create Index for Excel Inventory List

R

rix51

At this time I have about 30 worksheets in my inventory workbook. Each
worksheet is of a specific inventory catagory such as one worksheet will be
switches, another would be converters etc. I expect to have over 150
sworksheet entries by the time I'm done. I need to have a "cover page" that
displays when I first open the Index Project. On this "cover page" I would
like to put an index of the what is inside so someone could click on a noun
name and they would be taken to that specific worksheet. Or, is there an
application already created that I could plug in and the application would
have a dialog box where you could type in what you are looking for and hit
enter. Then a matching worksheet would be displayed. Thanks for your time
and consideration.
 
B

Bernard Liengme

Two things to do:
A) You want the book to open on the 'front' sheet each time.
With the workbook open, on the menu bar next to File there is an Excel logo
(green X); right click this; select View Code. In the Module window paste
this:

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub

Change "Sheet1" to suit your need


B) You want to click a cell and have a specific sheet open
On the "Front" page, in some suitable place (mid window) type a list of
names (intrigued by term 'noun name' !) corresponding to each of your
worksheet content ( Switch, Converter, Transformer, Widget, Klystron .....)
Right click each cell in turn; select Hyperlink. On the Hyperlink dialog,
select Place in this Document on left hand panel, then in window (you may
have to wait some seconds) select the corresponding worksheet name.

Question: DO you want the user to return to the "front page"?
Add a hyperlink on each inventory page: Back to Table of Contents and
reference the "front page"

Best wishes
 
R

rix51

Bernard Liengme said:
Two things to do:
A) You want the book to open on the 'front' sheet each time.
With the workbook open, on the menu bar next to File there is an Excel logo
(green X); right click this; select View Code. In the Module window paste
this:

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub

Change "Sheet1" to suit your need


B) You want to click a cell and have a specific sheet open
On the "Front" page, in some suitable place (mid window) type a list of
names (intrigued by term 'noun name' !) corresponding to each of your
worksheet content ( Switch, Converter, Transformer, Widget, Klystron .....)
Right click each cell in turn; select Hyperlink. On the Hyperlink dialog,
select Place in this Document on left hand panel, then in window (you may
have to wait some seconds) select the corresponding worksheet name.

Question: DO you want the user to return to the "front page"?
Add a hyperlink on each inventory page: Back to Table of Contents and
reference the "front page"

Best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

Solution B worked out perfectly. An elegant answer with simplicity of use.
Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top