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" wrote:

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" wrote:

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?