Headers/Footers from a named range of cells in a worksheet

[RMort]

I want to create a set of cells for address information where a customer can
fill in there address and it will automatically populate into the Header of
another worksheet in the same workbook. Is this possible?

 

[Sheeloo]

If you want the same values in another sheet then go to the cell you want it
to be
Type =
Click on the source sheet and then the cell you want
press ENTER
Repeat for other cells or drag the formula
and you are done

 

[RMort]

I think you misunderstood my question. I want the value of a named range to
populate the Header of the page when it is printed. Sorry if I wasn't clear
initially.

 

[Sheeloo]

As far as I know,

you can not use Named range in the header. You have to select the "Rows to
repeat at top".

Also you can not use a range from another sheet to print as header...