Nov 20 2022 06:08 PM
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?
Nov 21 2022 02:13 AM
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