In our excel files we have variables in specific cells, however I would like to add them to the header and the footer. So they are not in the way when we update the formats of files.

Is this possible? Do I need to use a macro, just as we do for adding the variables to a word documents' header or footer?

Thanks,

Laura