relative address

  • Thread starter Thread starter Race1530
  • Start date Start date
R

Race1530

if this is the formula

=sum(sheet26:sheet35!K4)

i understand it will sum the values of k4 on all sheets between 26 and 35
inclusive.

I want to copy that formula to sheet 46 and have it automatically change the
formula to

=sum(sheet36:sheet45!K4)

But when I copy, the formula remains static to the orginal. What am I doing
wrong. Thanks

Mike
 
Excel does not support this automatic change as you have described it.
Click to expand...
...

Not with built-in functionality, but udfs can handle it. See my response to the
OP in the multipost in microsoft.public.excel.worksheetfunctions.
 
Harlan Grove said:
... it.
..

Not with built-in functionality, but udfs can handle it. See my response to the
OP in the multipost in microsoft.public.excel.worksheetfunctions.
Click to expand...

Hi Harlan
I hate multiposts.......

nice UDF BTW

Best regards
Frank
 
Back
Top