VBA Tutorial - Create An Index Page

I want to Create a Excel Sheet That includes an Index Page

I have 10 Folders and 5 - 10 Workbooks in Each Folder
What i have to do is to create an Index catalogue includes all the workbooks names in a Excel , and whenever i click the index numbers the linked workbook should be opened...

Can Anybody give me an example or tell me how to do that ..........

Hi,

I am trying to create an index in Excel. Basically Column A has names in it and Column B will have page numbers. I have 9 tabs. Is there a way for Excel to let me know the page number(s) the names are on and insert them into column B?

Thanks for your help!

Hi I have spent a lot of time looking through the forum for this and thought I had found it in the following code. I need an index page that is linked to each sheet in the workbook for easy access to the worksheets.

Code:

Private Sub Worksheet_Activate()

Dim wSheet As Worksheet

Dim l As Long

l = 1



    With Me

        .Columns(1).ClearContents

        .Cells(1, 1) = "INDEX"

        .Cells(1, 1).Name = "Index"

    End With

    

    For Each wSheet In Worksheets

        If wSheet.Name <> Me.Name Then

            l = l + 1

                With wSheet

                    .Range("A1").Name = "Start_" & wSheet.Index

                    .Hyperlinks.Add Anchor:=.Range("A1"), Address:="", _

                    SubAddress:="Index", TextToDisplay:="Back to Index"

                End With

                

                Me.Hyperlinks.Add Anchor:=Me.Cells(l, 1), Address:="", _

                SubAddress:="Start_" & wSheet.Index, TextToDisplay:=wSheet.Name

        End If

    Next wSheet

When I try and run this I get a "Compile error: Expected : Named Parameter" starting at " .Hyperlinks.add Anchor" Line of code.
Not being good with VBA I cannot get it to work any help appreciated.

Morning all,

Can anyone suggest a good tutorial on linking Access to Excel, possibly through data access pages?

I have a spreadsheet "Map" of the country, and lots of data stored by different scenarios in Access. What I'd like to get to is something where I can pick a scenario, and for that data to be shown on said map.

The table structure is roughly as follows

Scenario:
ScenarioName
Year
Situation

Supply Point:
Node
Volume
ScenarioName

It shouldn't be very complicated to link the two together, but not sure how to start this one off.

I want to record the keystrokes (preferably with pauses) with an audio
commentary so that I can create mini tutorials for distribution to my
colleagues

Hi,

It's my first post, so please be nice!

I am doing a dissertation that involves looking at house prices. My simple question is this, I have 2 different data sets of house prices over time and want to make an index of them, so I can map them on a graph starting at 100%. (I hope that makes sense).

How do I create an index of the data? I have tried typing "=INDEX" but haven't managed to figure it out...?

Any help would be great and if you need clarification on anything let me know (I'm dyslexic)!

Sorry - topic is slightly inaccurate - I meant nth copy of page 3....

Building a spreadsheet to help with employee benefit rate calculations. Data for employees is listed in the first sheet, rate information is on the second page and each subsequent page is for each employee. The pages 3 to nth contain the formulas the referencing page 2 and page 1 information.

I've got page 1 done and page 2 and 3 (first employee) done. I'd now like to enter employee data on the first page and have it autopopulate the nth pages using the formulas from page 3.

Summary.

Page 1 - employee list with data
Page 2 - data to calculate benefit info
Page 3 to nth - employee information formulas.

How do I get excel to generate an nth page if I add an employee
to page 1 (new row) using all formulas from page 3 (I can make it a template).

How do I get excel to change the new nth page reference to page 1 and row so the new page has to access the new employee line (new row).

thanks in advance....

PS. Auto naming the new page tab would be very nice with the employees name from page one when its entered....

I have an xls file with a list of names and other information. I export this file to Access and run a report. I would like to create an index page that shows which page of the report a person's name appears. How can I do this? I am a bit stumped. Thanks.

I have an index page which links to each worksheet in the workbook. I just added a new sheet. How do I just add a link for just the new sheet and put it on my index page?

I want to create a form on tab 1 to enter new data. Once the data is entered, I want to add a click box to grab the data and automatically drop the data onto the master list on another tab. Ideally, I would want the master listing to be restricted access also. I can do everything except for the macro that grabs the new data and adds it to the list of data in the next available row. I could write the macro to drop the new info on row 64000 and then have it sort the list also by date, but I assume there is a way to have it do that for me.

thank you!

Eric