View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Larry Kahm Larry Kahm is offline
external usenet poster
 
Posts: 3
Default Increment cell reference

=INDEX(INDIRECT("'"&$A3&"'!$G5"),COLUMNS($A:$A))

How can I get the variable, "G5" to increment when copied across a row or
down a column (i.e., $G5, $G6, $G7, etc)

I've tried copy and then paste special, formula, but it doesn't increment.
What should I be doing?

Thanks

Larry