Re: Absolute cells and worksheets

From: Louise (anonymous_at_discussions.microsoft.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 07:40:01 -0700

thank you for your reply, however, it doesn't seem to
have worked and I'm not quite sure why. It simply
returns a 'REF' error. Any idea where im going wrong???
Thanks.

Louise

>-----Original Message-----
>A workaround since sheets don't use relative referencing
>
>
>=INDIRECT("'Week "&ROW(23:23)&"'!$E$10")
>
>
>
>--
>
>Regards,
>
>Peo Sjoblom
>
>(No private emails please, for everyone's
>benefit keep the discussion in the newsgroup/forum)
>
>
>"Louise" <anonymous@discussions.microsoft.com> wrote in
message
>news:2903101c464de$938b6540$a401280a@phx.gbl...
>> Hi all
>>
>> I have a formula in a cell which reads ='Week 23'!
$E$10.
>> When I copy the formula down to the next row, I would
>> like it to look at the following week's work***, ie.
>> Week 24 and the same cell, hence the absolute
reference.
>> However, when I drag the formula down, it still refers
to
>> Week 23 - how can I get it to automatically go to the
>> next work***?
>>
>> Thanks.
>>
>> Louise
>
>
>.
>