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" <(E-Mail Removed)> wrote in message
> news:09A997B4-D061-4E1C-8EA7-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:7EEBA3E9-65BE-4422-9178-(E-Mail Removed)...
> >> >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" <(E-Mail Removed)> wrote in message
> >> >> news:16F6DE02-2195-4DB8-B40A-(E-Mail Removed)...
> >> >> > How can I create a date variable that I can use in both column and
> >> >> > worksheet
> >> >> > headings?
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
|
Similar Threads
