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 in Others by Kithuzzz
• 20,660 points
50 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 by narikkadan
• 37,660 points

Related Questions In Others

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 in Others by narikkadan
• 37,660 points
50 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 in Others by narikkadan
• 37,660 points
72 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 in Others by narikkadan
• 37,660 points
27 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25 in Others by narikkadan
• 37,660 points
19 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 in Others by narikkadan
• 37,660 points
30 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,720 points
451 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
2,218 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 in Others by gaurav
• 22,040 points
69 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 in Others by narikkadan
• 37,660 points
119 views
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 in Others by narikkadan
• 37,660 points
85 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