|  | Date variables for Column and Worksheet Headings | | |
| | | Ann |  |
|  Posted: Mon Jul 07, 2008 10:31 am Post subject: Date variables for Column and Worksheet Headings |  |
How can I create a date variable that I can use in both column and worksheet
headings? |
| |
| | | Rick Rothstein (MVP - VB) | |
| | Posted: Mon Jul 07, 2008 3:08 pm Post subject: Re: Date variables for 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...
| Quote: | How can I create a date variable that I can use in both column and
worksheet
headings? |
|
| |
| | | Ann | |
| | Posted: Mon Jul 07, 2008 7:06 pm Post subject: Re: Date variables for 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:
| Quote: | 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?
|
|
| |
| | | Pete_UK | |
| | Posted: Mon Jul 07, 2008 7:41 pm Post subject: Re: Date variables for 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...
| Quote: | 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?
|
|
| |
| | | Ann | |
| | Posted: Mon Jul 07, 2008 7:53 pm Post subject: Re: Date variables for 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:
| Quote: | 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?
|
|
| |
| | | Pete_UK | |
| | Posted: Mon Jul 07, 2008 8:15 pm Post subject: Re: Date variables for 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...
| Quote: | 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?
|
|
| |
| | | Ann | |
| | Posted: Tue Jul 08, 2008 1:15 pm Post subject: Re: Date variables for Column and Worksheet Headings | |
| | | |
Thanks Pete, I didn't know about grouping worksheets for headers.
Ann
"Pete_UK" wrote:
| Quote: | 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?
|
|
| |
| | | Pete_UK | |
| | Posted: Tue Jul 08, 2008 5:16 pm Post subject: Re: Date variables for 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...
| Quote: | Thanks Pete, I didn't know about grouping worksheets for headers.
Ann
|
|
| |
|
|
