"rw" wrote in message
m...
Mr. Opus McDopus wrote:
"riverman" wrote in message ...

In Excel, how can I make worksheet references relative?

For example, I want to insert the following in row 3, in cells A through
Z:

Sheet2!$B$5 Sheet3!$B$5 Sheet4!$B$5 Sheet5!$B$5 etc.

I know how to make the cell number absolute (with the $-signs), but I
cannot get the 'fill' to change the sheets when I drag the function
command across the different cells in row 3: it keeps the worksheet
reference absolute, referencing Sheet2. How can I make the worksheet
reference relative, so it changes the sheet number for each successive
cell?

--riverman


I subscribe to microsoft.public.excell.worksheetfunctions and it appears
to be a very active NG (53,854 posts).

microsoft.public.excel.newuser had 9746 post

Is there possibly some kind of ObRoff you guys could stick here? I mean,
like, there are plenty of Geek newsgroups.

BTW, Happy Birthday, Myron. I'll be 60 in February, so **** you.


60!? Holy crap, when my grandparents were your age, they were dead already!

--riverman

oh, and ObRoff: FYT
g