Prev: formula to look up ref in one sheet and offset in another
Next: How to I combine excel worksheets?
From: Malcolm on 25 May 2010 11:38
I have a workbook that contains 18 sheets. Is it possible to change the date
on sheet 1 and have it change on the other 17 sheets, even though the sheets
contains two different date formats, 5/25, and 5/25/10, and all of the sheets
are different than sheet 1? I'm using Excel 2007.
Thanks,
Malcolm

From: Gord Dibben on 25 May 2010 12:25
Link each of the date cells on 17 sheets back to the main sheet where you
will change the date.

=Main!A1 where A1 is the changing date.

Each sheet formatted to your choice.


Gord Dibben MS Excel MVP


On Tue, 25 May 2010 08:38:01 -0700, Malcolm
<Malcolm(a)discussions.microsoft.com> wrote:

>I have a workbook that contains 18 sheets. Is it possible to change the date
>on sheet 1 and have it change on the other 17 sheets, even though the sheets
>contains two different date formats, 5/25, and 5/25/10, and all of the sheets
>are different than sheet 1? I�m using Excel 2007.
>Thanks,
>Malcolm

From: Malcolm on 25 May 2010 13:40
Gord, Hi,
I must be doing something wrong. The first sheet is called Cash Audit and
the date cell is B4, so should the date cells on the other sheets look like
this: =Cash Audit!B4? Because when I put =Main!B4 into the other sheets a
different date appeared.

Thanks,
Malcolm

"Gord Dibben" wrote:

> Link each of the date cells on 17 sheets back to the main sheet where you
> will change the date.
>
> =Main!A1 where A1 is the changing date.
>
> Each sheet formatted to your choice.
>
>
> Gord Dibben MS Excel MVP
>
>
> On Tue, 25 May 2010 08:38:01 -0700, Malcolm
> <Malcolm(a)discussions.microsoft.com> wrote:
>
> >I have a workbook that contains 18 sheets. Is it possible to change the date
> >on sheet 1 and have it change on the other 17 sheets, even though the sheets
> >contains two different date formats, 5/25, and 5/25/10, and all of the sheets
> >are different than sheet 1? I'm using Excel 2007.
> >Thanks,
> >Malcolm
>
> .
>
From: Gord Dibben on 25 May 2010 14:20
='Cash Audit'!B4 would be correct in all 17 other other sheets.

"Main" was an example only but if you are getting a date and not a #REF!
error using =Main!B4 you must have a sheet named Main.


Gord


On Tue, 25 May 2010 10:40:02 -0700, Malcolm
<Malcolm(a)discussions.microsoft.com> wrote:

>Gord, Hi,
>I must be doing something wrong. The first sheet is called Cash Audit and
>the date cell is B4, so should the date cells on the other sheets look like
>this: =Cash Audit!B4? Because when I put =Main!B4 into the other sheets a
>different date appeared.
>
>Thanks,
>Malcolm
>
>"Gord Dibben" wrote:
>
>> Link each of the date cells on 17 sheets back to the main sheet where you
>> will change the date.
>>
>> =Main!A1 where A1 is the changing date.
>>
>> Each sheet formatted to your choice.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>>
>> On Tue, 25 May 2010 08:38:01 -0700, Malcolm
>> <Malcolm(a)discussions.microsoft.com> wrote:
>>
>> >I have a workbook that contains 18 sheets. Is it possible to change the date
>> >on sheet 1 and have it change on the other 17 sheets, even though the sheets
>> >contains two different date formats, 5/25, and 5/25/10, and all of the sheets
>> >are different than sheet 1? I�m using Excel 2007.
>> >Thanks,
>> >Malcolm
>>
>> .
>>

From: Malcolm on 25 May 2010 15:50
Gord, Hi,
You were spot on. Thanks for setting me straight and making my job easier.
Regards,
Malcolm

"Gord Dibben" wrote:

> ='Cash Audit'!B4 would be correct in all 17 other other sheets.
>
> "Main" was an example only but if you are getting a date and not a #REF!
> error using =Main!B4 you must have a sheet named Main.
>
>
> Gord
>
>
> On Tue, 25 May 2010 10:40:02 -0700, Malcolm
> <Malcolm(a)discussions.microsoft.com> wrote:
>
> >Gord, Hi,
> >I must be doing something wrong. The first sheet is called Cash Audit and
> >the date cell is B4, so should the date cells on the other sheets look like
> >this: =Cash Audit!B4? Because when I put =Main!B4 into the other sheets a
> >different date appeared.
> >
> >Thanks,
> >Malcolm
> >
> >"Gord Dibben" wrote:
> >
> >> Link each of the date cells on 17 sheets back to the main sheet where you
> >> will change the date.
> >>
> >> =Main!A1 where A1 is the changing date.
> >>
> >> Each sheet formatted to your choice.
> >>
> >>
> >> Gord Dibben MS Excel MVP
> >>
> >>
> >> On Tue, 25 May 2010 08:38:01 -0700, Malcolm
> >> <Malcolm(a)discussions.microsoft.com> wrote:
> >>
> >> >I have a workbook that contains 18 sheets. Is it possible to change the date
> >> >on sheet 1 and have it change on the other 17 sheets, even though the sheets
> >> >contains two different date formats, 5/25, and 5/25/10, and all of the sheets
> >> >are different than sheet 1? I'm using Excel 2007.
> >> >Thanks,
> >> >Malcolm
> >>
> >> .
> >>
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: formula to look up ref in one sheet and offset in another
Next: How to I combine excel worksheets?