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

  • Thread starter Thread starter RMort
  • Start date Start date
R

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?
 
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
 
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.
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Headers & Footers _auto update info from a cell in the worksheet 4
Change Header & Footer Info w/ Worksheet Option Buttons 1
How do I reference a cell to automatically update in a header 1
How do I make a single header/footer common across all worksheets? 1
Linking cells to Headers and Footers 4
Header and Footer margins 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top