Hi
Not sure what you VBA Macro skills are like but I would have thought you could write an If....Then....Else routine to check what the header is and then populate the footer based on the header.
Hope this helps.
Tony