Prev: formula to look up ref in one sheet and offset in another
Next: How to I combine excel worksheets?
From: Gord Dibben on 25 May 2010 15:59
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
<Malcolm(a)discussions.microsoft.com> wrote:

>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
>> >>
>> >> .
>> >>
>>
>> .
>>

First  |  Prev  | 
Pages: 1 2
Prev: formula to look up ref in one sheet and offset in another
Next: How to I combine excel worksheets?