Create Index for Excel Inventory List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 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
Click to expand...

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