Forum Discussion

DonWFarr's avatar
DonWFarr
Copper Contributor
Nov 21, 2022

Need to generate an index list from workbook pages

I have a workbook with 69 pages.  each page has student name field and a student ID#.

 

I need to create an index list of the students and their ID#s, how can I do that?

excel

1 Reply

Sort By
  • tauqeeracma's avatar
    tauqeeracma
    Steel Contributor
    Nov 21, 2022

    Hi DonWFarr 

     

    As per my understanding, you need to generate an index (Hyperlink) for all 69 sheets with a formula rather than doing it manually for each sheet.

     

    You can achieve your requirement using the below formula:

    =HYPERLINK(CELL("address",INDIRECT((B4&"!"&"C3"))),B4)

    Paste this formula in the first cell and drag it for all 69 sheets. Please also refer to a sample file for more clarity.

     

    Please let me know if it works for you.

     

    Thanks

    Tauqeer

Resources