I have a report where the main body will refer to unique identifying codes below photos in an appendix. The photos/unique identifiers are listed in the appendix only once. The unique code is what is referenced in the main report, and it may be referenced more than once in the report.



The report will be written independent of the appendix, and then the docs probably combined together after both are complete. I want to run a macro to have the references in the main report linked to where the unique reference is in the appendix.

This doesn't sound too novel, so maybe something exists already to do this?

Any pointers?