Date variables for Column and Worksheet Headings

  • Thread starter Thread starter Ann
  • Start date Start date
I'm not clear on what you are asking for... can you provide more details
please?

Rick
 
I have a workbook with multiple worksheets. There are dates within the
headers of each worksheet and the column headings of multiple columns with
the spreadsheets. I'd like to create a variable on the first worksheet that
I can enter the date (e.g. forecast date) and have all of the headers on all
of the worksheets use that date rather than manually updating each header
with the new date. Is there a way to do this?

Thanks

Ann
 
Suppose your date is in A1 of Sheet1, and you want this to be reflected in
D1 of the other sheets - you can do so with this formula:

=Sheet1!$A$1

If you only have a few sheets, then you can copy this to D1 of the other
sheets, but if you have several then you can group those sheets together by
holding the CTRL key and selecting each sheet tab in turn, and then you only
need to enter the formula once and it will automatically go into that cell
in all the sheets which are grouped together. You should Ungroup the sheets
when finished, by right-click on a sheet tab.

Hope this helps.

Pete
 
Thanks Pete, Does this work to insert the date into a Text Column Header or
in a Worksheet Header?
 
I thought you were talking about column headers, but having re-read your
first post I think you are talking about both. For a sheet header, you can
again group all the sheets together that you want this to apply to and then
click on File | Page Setup | Headers and Footers. Now, whatever you define
in the header will be reflected in all the other sheets that are grouped, so
you only need to put the date in once.

Again, don't forget to ungroup the sheets when finished.

Hope this helps.

Pete
 
Back
Top