Attached is a link to a Word doc sample of the Songbook from which I am extracting whole songs to go into a new doc "GigName". The list of page numbers is in a workbook named "SetListCreator". Whilst extracting the songs, I'm also extracting the title to paste next to the page number.

The reason for activating the sheets is that I don't know any other way. I assume I have to Activate the SetListCreator.doc to get the next page number, Activate the LatestSongbook to copy the relevant page, Activate the GigName doc to paste the song in, and Activate the SetListCreator again to paste the song title next to the pabe number.

https://www.msofficeforums.com/attac...1&d=1758882020

The additional extraction is the song key, so on the case of the attached sample the red [G] from page 1, [Am] from p2, [G] from p3, and [F] from p4. Note that on p4 I would not want the [F / / /]. The song key is always 1 or 2 A-Z characters inside square brackets [ ].

Your assistance is greatly appreciated.

Attached Files

Songbook Sample.docx (131.7 KB, 3 views)