Excel Header & Footers in Templates - Assigning workbook specific
 

I have template that is being used for data gathering and the customer is
requesting the printed workbook result should reflect the value of one of the
fields that is being updated during the data gathering - I cannot change the
logic in the file naming convention internally to accomodate this (which
would be the easy fix)

Is there a way to set the header entry to concatenate a field in the
workbook without forcing the reps to manually update the headers??