TywithXl
New Member
- Joined
- Jan 29, 2020
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
Scenario: I have multiple workbooks(20+). They all have a worksheet with the same name (ABC).
Sheet ABC has 3 sections and these sections begin with the title of the section e.g. Section 1, Section 2 and Section 3
Issue: There are many rows (2000+) separating each section. Issue 2: Each workbook has the three sections in different rows but all section names are in the same column (Column C).
I currently have the 3 sections on the top of the worksheet and use ctrl + F to find each section and hyperlink the top of the worksheet to these cells which is time consuming for multiple workbooks.
How can I automate the creation of a list that links to each section of the sheet, for each workbook?
Sheet ABC has 3 sections and these sections begin with the title of the section e.g. Section 1, Section 2 and Section 3
Issue: There are many rows (2000+) separating each section. Issue 2: Each workbook has the three sections in different rows but all section names are in the same column (Column C).
I currently have the 3 sections on the top of the worksheet and use ctrl + F to find each section and hyperlink the top of the worksheet to these cells which is time consuming for multiple workbooks.
How can I automate the creation of a list that links to each section of the sheet, for each workbook?