How can I create a date variable that I can use in both column and worksheet
headings?

I'm not clear on what you are asking for... can you provide more details
please?

Rick


"Ann" <Ann@discussions.microsoft.com> wrote in message
news:16F6DE02-2195-4DB8-B40A-735411C2D463@microsoft.com...
> How can I create a date variable that I can use in both column and
> worksheet
> headings?

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

"Rick Rothstein (MVP - VB)" wrote:

> I'm not clear on what you are asking for... can you provide more details
> please?
>
> Rick
>
>
> "Ann" <Ann@discussions.microsoft.com> wrote in message
> news:16F6DE02-2195-4DB8-B40A-735411C2D463@microsoft.com...
> > How can I create a date variable that I can use in both column and
> > worksheet
> > headings?
>
>

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

"Ann" <Ann@discussions.microsoft.com> wrote in message
news:7EEBA3E9-65BE-4422-9178-245C5C824D83@microsoft.com...
>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
>
> "Rick Rothstein (MVP - VB)" wrote:
>
>> I'm not clear on what you are asking for... can you provide more details
>> please?
>>
>> Rick
>>
>>
>> "Ann" <Ann@discussions.microsoft.com> wrote in message
>> news:16F6DE02-2195-4DB8-B40A-735411C2D463@microsoft.com...
>> > How can I create a date variable that I can use in both column and
>> > worksheet
>> > headings?
>>
>>

Thanks Pete, Does this work to insert the date into a Text Column Header or
in a Worksheet Header?

"Pete_UK" wrote:

> 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
>
> "Ann" <Ann@discussions.microsoft.com> wrote in message
> news:7EEBA3E9-65BE-4422-9178-245C5C824D83@microsoft.com...
> >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
> >
> > "Rick Rothstein (MVP - VB)" wrote:
> >
> >> I'm not clear on what you are asking for... can you provide more details
> >> please?
> >>
> >> Rick
> >>
> >>
> >> "Ann" <Ann@discussions.microsoft.com> wrote in message
> >> news:16F6DE02-2195-4DB8-B40A-735411C2D463@microsoft.com...
> >> > How can I create a date variable that I can use in both column and
> >> > worksheet
> >> > headings?
> >>
> >>
>
>
>

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

"Ann" <Ann@discussions.microsoft.com> wrote in message
news:09A997B4-D061-4E1C-8EA7-B2D955169872@microsoft.com...
> Thanks Pete, Does this work to insert the date into a Text Column Header
> or
> in a Worksheet Header?
>
> "Pete_UK" wrote:
>
>> 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
>>
>> "Ann" <Ann@discussions.microsoft.com> wrote in message
>> news:7EEBA3E9-65BE-4422-9178-245C5C824D83@microsoft.com...
>> >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
>> >
>> > "Rick Rothstein (MVP - VB)" wrote:
>> >
>> >> I'm not clear on what you are asking for... can you provide more
>> >> details
>> >> please?
>> >>
>> >> Rick
>> >>
>> >>
>> >> "Ann" <Ann@discussions.microsoft.com> wrote in message
>> >> news:16F6DE02-2195-4DB8-B40A-735411C2D463@microsoft.com...
>> >> > How can I create a date variable that I can use in both column and
>> >> > worksheet
>> >> > headings?
>> >>
>> >>
>>
>>
>>

Thanks Pete, I didn't know about grouping worksheets for headers.

Ann

"Pete_UK" wrote:

> 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
>
> "Ann" <Ann@discussions.microsoft.com> wrote in message
> news:09A997B4-D061-4E1C-8EA7-B2D955169872@microsoft.com...
> > Thanks Pete, Does this work to insert the date into a Text Column Header
> > or
> > in a Worksheet Header?
> >
> > "Pete_UK" wrote:
> >
> >> 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
> >>
> >> "Ann" <Ann@discussions.microsoft.com> wrote in message
> >> news:7EEBA3E9-65BE-4422-9178-245C5C824D83@microsoft.com...
> >> >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
> >> >
> >> > "Rick Rothstein (MVP - VB)" wrote:
> >> >
> >> >> I'm not clear on what you are asking for... can you provide more
> >> >> details
> >> >> please?
> >> >>
> >> >> Rick
> >> >>
> >> >>
> >> >> "Ann" <Ann@discussions.microsoft.com> wrote in message
> >> >> news:16F6DE02-2195-4DB8-B40A-735411C2D463@microsoft.com...
> >> >> > How can I create a date variable that I can use in both column and
> >> >> > worksheet
> >> >> > headings?
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

You're welcome, Ann - thanks for feeding back.

Pete

"Ann" <Ann@discussions.microsoft.com> wrote in message
news:06287F6C-47CE-4DE2-9207-BEEDA5DF71A6@microsoft.com...
> Thanks Pete, I didn't know about grouping worksheets for headers.
>
> Ann
>