Absolute references

  • Thread starter Thread starter Louise
  • Start date Start date
L

Louise

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 worksheet, 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 worksheet?

I posted this message a few days ago and did receive a
reply, however, I can't get it to work.

Any suggestions?

Thank you.

Louise
 
Louise, please stay in the original thread, posting the same question more
than once
is frowned upon in these groups. Believe me, my formula will work, see
answer to your earlier post.
Btw, if you want to increase the sheet names the way you indicated there is
no other way using
copy down

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Hi
try the following:
=INDIRECT("'Week " & 22+ROW(1:1) & "'!E10")
and copy this down
 
Guess what, that's the same formula I gave to her to her earlier question<g>

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Peo Sjoblom said:
Louise, please stay in the original thread, posting the same question
more than once is frowned upon in these groups. . . . ....
"Louise" <[email protected]> wrote in message
Click to expand...
....

The problem is with how the OP reads and writes newsgroup messages. She's
using CDO, and CDO has the unfortunate design that threads are sorted in
order of the date stamp of the original posting. At least that's in
descending order. Anyway, in high volume newsgroups with many initiated
threads per day, it doesn't take long for any thread to move to the second
or further pages of threads, and most new posters aren't aware that they'd
need to page through the listings to find their threads along with the
reponses to them.

excelforum and Google Groups both handle this better: threads are sorted by
the date of the most recent respones. It's still necessary from time to time
to page through the thread listings, but not as often as it is with CDO, and
God help anyone using CDO to follow threads initiated days ago.

That said, even CDO provides a search facility, and the new CDO interface
does do a better job with that the old CDO interface - the new interface
returns entire threads in which some message(s) in the thread match(es) the
search criteria while the old interface returned only the matching messages.
So Microsoft has definitely improved CDO, but its a mystery why they're
still supporting the old, awful interface. Anyway, the OP needs to use the
search facility to locate her threads. If only there were a chance she'd see
these responses . . .
 
Back
Top