Hi Paul.

FYI: I didn't see anything attached this time.

I have retained the code that works with your original workbook structure; I see no advantage in changing it.

-- I think the advantage of the data in the second workbook is that the current method requires me to know which I Can Statements fall under each progress title (Intermediate Apprentice, etc.) in order to land on the right I Can Statement. I need to see all the I Can Statements in order to choose the one that best fits the lesson. I also like the fact that the progress titles are available at the end of each I Can Statement as that is information my administration likes to see.

Do you mean that, if you choose Knowledge, the choices that become available are all of the entries on that sheet? If so, you could only choose one of those 30-40 entries, whereas the current process allows you to output all that are applicable to Distinguished, for example, and gives you the ability to delete any you don't want and/or to re-word the ones that are there.

-- Yes!!!! That's it!!!! "When selected, all the entries on that sheet." That's it! I'm sorry - I didn't know how to word it like that to at the start.
That's the preferred method - choose the Domain (Knowledge, Research, etc.) and then choose only one of those 30-40 entries. If I need two I Can Statements from Research, I can choose Research in LearningTarget1 Box and LearningTarget2 Box.

That would be what's needed.
:0)