ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I reference Cell information in my Headers? (https://www.excelbanter.com/excel-discussion-misc-queries/52536-how-do-i-reference-cell-information-my-headers.html)

P Alicea

How do I reference Cell information in my Headers?
 
I am setting up worksheets for my office that will help us to increase
productivity. One of the essential pieces of information needed on each
sheet is the project number and name. If I create a chart, how do I get the
headers for the chart to reference the project number and name from another
sheet? The Chart is located on it's own sheet.

tkaplan

How do I reference Cell information in my Headers?
 

If i am not mistaken, you cannot reference it in the header. what you
can do is at the top of your chart reference the project name, number,
etc. then you can have that line print at the top of each page.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=479824


P Alicea

How do I reference Cell information in my Headers?
 
How do I reference the project name and number on the top of the chart? By
chart, I mean graph. I apologize for any confusion.

"tkaplan" wrote:


If i am not mistaken, you cannot reference it in the header. what you
can do is at the top of your chart reference the project name, number,
etc. then you can have that line print at the top of each page.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=479824




All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com