Hi,

Definitions.xlsm

In the attached example what I want to do is take the information on the data page as specified by the inputs page and copy and paste each definition on a different page called definitions. The complication is that I need to find the term which is always stored after a colon. Would it be possible to copy this information after the colon into one column and then the definition next to it?

The inputs page is meant to help the macro know where to look on the data page.

Thanks!