| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link a print header to variable data in multiple workshee
I would like to be able to create a reference or link in an
Excel header or footer that will look to a certain cell in several worksheets and pick up the data there. Say for example, I have a workbook with five worksheets and each worksheet has a different manager's name in cell A2. I want to be able to put a link or reference in the header or footer so that when the document is printed, each worksheet will have the correct manager's name. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort does not recognize the header row | New Users to Excel | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Link multiple worksheets while extracting data | Excel Worksheet Functions | |||
| Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
