Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Changing dates across multiple worksheets

2,505 views
Skip to first unread message

Malcolm

unread,
May 25, 2010, 11:38:01 AM5/25/10
to
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

Gord Dibben

unread,
May 25, 2010, 12:25:39 PM5/25/10
to
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

Malcolm

unread,
May 25, 2010, 1:40:02 PM5/25/10
to
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:

> .
>

Gord Dibben

unread,
May 25, 2010, 2:20:42 PM5/25/10
to
='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

Malcolm

unread,
May 25, 2010, 3:50:01 PM5/25/10
to
Gord, Hi,
You were spot on. Thanks for setting me straight and making my job easier.
Regards,
Malcolm

"Gord Dibben" wrote:

> .
>

Gord Dibben

unread,
May 25, 2010, 3:59:44 PM5/25/10
to
Thanks for the feedback.

You must have managed to figure out what "other other" meant<g>


Gord

On Tue, 25 May 2010 12:50:01 -0700, Malcolm

0 new messages