View Single Post
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default Indirect reference to another sheet that can be dragged

Brian wrote...
....
. . . I saw one member posted an example saying =INDIRECT("" & $A$1
&"!K11"). But I was not able to drag this down the column. I am looking for
Sept! K11 would equal Oct! K11 , and Sept! K12 would equal Oct! K12 and so
on. . . .


No matter what the cell, if you want cell ZZ## in the active worksheet
to equal the value in cell ZZ## in the worksheet nemed in cell A1 in
the active worksheet, try

=INDIRECT("'"&$A$1&"'!RC",0)