Extracting certain text before footnote number

[Taisir]

Dear All,
I have large number of documents (800 plus) exported from a database that are all in the same format.

Every document contains Names of authors of large research projects. All names are written in the same format, Last Name, (Comma) First Initials (in Hypertext) followed by the same name within parenthesis in regular text along with a footnote designating the author affiliated organization. All name listed in alphabetical order. Please see attached sample.

I need a VBA (Macro) that can pull the names associated with certain footnote number and place them at the bottom of the document. For example for organization associated with the number “34”, the desired output will be:

Aefsky, S
Amelung, C
Bensinger, J. R
Bianchini, L
Blocker, C

So whenever I need to pull the name of certain organization, all what I need to do is change the footnote number in the VBA and run it again.



Many thanks in advance for any help

All the best Taisir