Oct 16 2019 12:58 PM
I see that I can pull file names and sheet names to a sheet header. Is it possible to pull/link the data from a certain cell to the header instead?
Oct 16 2019 01:18 PM
Hello @JimR-0216,
This would be possible with VBA. For example, if cell A1 contains text that you would like to place as a header, then open up VBA, create a new module, and put the following:
Sub Wksht_HeaderChange()
ActiveSheet.PageSetup.CenterHeader = Range("A1").Text
End Sub