Hello, everyone. I have a dilemma. I need to create an index of over 1700 songs by alphabetical order, where the index entries (which are the song titles) have to be hyperlinked to the particular song in the word document. I have manually added all the index entries (song titles) but the index entries are not hyperlinked so they won't go to the particular song when clicked on. So when I generate the PDF, it won't go there.

However, I have also started to bookmark the song titles, where the bookmark names are A_1, A_2, A_3, A_4, etc. Then when I cross-reference the index entries to the bookmark name, the index entries in the PDF does go to the particular song. However, I'm trying to save manual work with a macro.

Can anyone help me with this macro. I did write a macro but the entries were not alphabetized. Instead the order was A_1, A_2, etc instead of the song title itself.