Macros like this rely on patterns to identify the targets. If you don't give full details on what patterns are in and what are out then the macro may not work as expected.

If YOU want code that works with YOUR document, YOU need to provide a sample document so we can see what pattern can be used. Otherwise we are making guesses and have to either provide untested code or do a test on an artificial sample document that we have to create based on your sketchy provided information.

Ideally, instead of a colour, you would have used a style on the footnotes you wanted to transfer and the pattern used by the macro could have been less nuanced.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia