Excel create an Index on the first sheet with links to subsequent sheets

0 votes

There are 12 worksheets in my workbook. The index is on the first worksheet, while the data for the index is on the other eleven sheets. This Workbook makes reference to a file tree structure, and my goal is to connect each Folder name to the appropriate Worksheet. These folders have names like "Folder 1, Folder 2," etc. Actually, each folder name is distinct.

The table below is the folder tree.

enter image description here

I need to name the worksheets based on their breadcrumbs. So For example Folder 3 Would be

Folder 1>Folder 2>Folder 3

With the limit being set as 31 characters, Any directories 6 deep with long names wouldn't fit. So I have the table below.

enter image description here

How do I approach this? The worksheets are in the correct order; all I need to do is link to the first table and batch rename them based on their paths so that when users click on Folder 8, they will see tabs F1.F6.F8.

Oct 21, 2022 in Others by Kithuzzz
• 38,010 points
1,090 views

1 answer to this question.

0 votes

This seems to be a potential duplicate of Excel - A hyperlink to a worksheet whose name is found in a cell over at Stackoverflow Superuser.

This answer shows how to use the Hyperlink function in excel to take a value from a cell (your worksheet name column) and use this to link to another tab.

=HYPERLINK(CONCATENATE("#", [cellcontainingthetabname], "!A1"), [textyouwishtodisplay])
answered Oct 22, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

Is there a way to lock cells after editing an excel sheet that's on sharepoint?

The Excel Web version (which, based on ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
1,106 views
0 votes
1 answer

How Can I Round Prices to the nearest 0.95 with an Excel Formula?

Try this: =IF(OR(A3-FLOOR(A3,1)>0.95,A3=CEILING(A3,1)),CEILING ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 63,720 points
554 views
0 votes
1 answer

How to hide and unhide the columns of an excel sheet using asp.net

Use this. For Row: worksheet_sub.Row(i).Height = 0; For Column: ...READ MORE

answered Oct 29, 2022 in Others by narikkadan
• 63,720 points
1,449 views
0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 63,720 points
760 views
0 votes
1 answer

Pass multiple Excel cell values to Power Automate

If you have certain data that you ...READ MORE

answered Nov 20, 2022 in Others by narikkadan
• 63,720 points
938 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
996 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,352 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
663 views
0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

answered Feb 6, 2023 in Others by narikkadan
• 63,720 points
703 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 63,720 points
1,070 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP