Pulling cell data to sheet header?

Copper Contributor

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?

1 Reply

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