Can someone help me, please! I have a single tab with over 3000+ rows of data. In column A, I have key values for each section. In the screenshot, I've provided, it shows the sections for 'image profiles' and also 'use cases'. My goal here is to use VBA to search through all of column A (row by row) and find '*/' which is right before each section. Once it finds '*/' it will read the next cell below the '*/' line and copy its contents into the top of the worksheet and also create a hyperlink to its location within the worksheet. Basically, a table of contents at the top of the worksheet. Can someone provide guidance on how to accomplish this? Thanks in advance for anyone who can help!


Untitled.jpg